When I open a new worksheet in an old file, it comes up without gridlines,
even thought the gridlines option is checked.

When I click on the gridlines option it only puts grid lines on data that
was copied from another area on the spreadsheet.