I just got Excel 2007 and having a little problem how to handle some cell formatting. Have a spreadsheet as a template which has several worksheets. Through an SSIS package the spreadsheet is copied and data is loaded correctly. My problem is formatting the cells. If I formatted the whole column, not all the formatting that is selected is applied. The only way I was able to get all the formatting to apply is for format the cell under the heading which results in a blank line. But another worksheet uses that data for a pivotTable which does not look right.

Also, a second problem is that one of the pivotTable loses its grid lines about half way down the page. The data still shows, but without grids lines.

Any help would be greatly appreciated!