One of our users has to do weekly updates to an Excel doc. She uses a saved Excel sheet that came from who knows where that had been formatted and has other sheets with graphs, etc. Anyway the problem is this Excel sheet lists procedures and things and they are counted and added numerically. When you open the sheet and view it, change data, etc, all is fine. Except that column A is missing. See pic.
But, when you print it, the numbers are off.
These numbers are fine until you print or preview the thing. Everything looks perfect, changes take effect, etc until you print. The printed copy has the number jump, but the actual sheet doesn't. I have tried unhiding, undo format, and everything I can think of. I even consulted a guy that teaches an Excel class and he couldn't figure it out. Any ideas?