Six Common Review and Production Problems: How to Fix Them August 2014 | Page 11

CHAPTER THREE
Spreadsheet and Database Files

POTENTIAL ISSUE: Spreadsheets are notoriously difficult to adapt into a
letter-sized format. There may be too many rows or columns to easily
read information and they may be blank, thereby creating thousands of
pages of unnecessary documents. If TIFFed, reviewers may miss hidden
columns, formulas, and other internal data (the same would be true if
spreadsheets were printed hard copy). There is no common solution to
how these spreadsheets are converted to images; one method is to
expose all hidden columns, sheets, etc. and another method is to print
with last known print settings.
RESOLUTION: The best practice is to review spreadsheets in their native
format, taking care to look for hidden rows, columns, sheets, and other
nonvisible data.

11