Hide/Display Hidden Cells By Default

[lmp101010]

When my boss opens my XLS reports it displays hidden cells by default, this makes the worksheets difficult to scan though, and the charts impossibly jumbled. Does anyone know how to adjust his settings to correct this?

[lmp101010]

Excel 2003

[ChemistB]

How are these "cells" being hidden? Are you hiding rows or columns or doing some sort of filter on the worksheet? If you save the workbook after you've filtered or hidden rows/columns, it should automatically open up the same unless he has some macros that are unhiding rows/columns. Maybe I'm missing something.

ChemistB

[lmp101010]

I am actually hiding the rows. Everyone else who views the reports does not see the hidden rows unless they expose them. Perhaps he does have a macro set up, although he is not aware of one.

[ChemistB]

You could hide the rows and then protect the spreadsheet (tools>protect>protect spreadsheet). That should stop him.

ChemistB