Hello,I am Pete, and I'll be happy to assist with your question today.
Random page breaks may appear if the page margins are set too tightly.
Have a look at the Page Settings and try different page sizes. If you see the error "Margins do not fit page size", then Excel 2010 will insert its own page breaks.
The hidden columns/rows problem is a lot stranger, and to delve more into this I would need to see the spreadsheet itself. It may be caused by a macro or other custom setting on the workbook.
If you would like me to take a look at the spreadsheet, you can upload it to www.wikisend.com and send me the file ID or download link.
Thanks for trying to help. I am familiar with the page settings. I think this may be some sort of config issue with excel 2010 and was hoping someone would just recognize the problem.
The page break problem seems to be resolved, however it is still doing some kind of linking thing. For instance, when I change text date in cell d9 it creates a validate or name error in e8 and these two cells are not related.
file id is 333970
Go onto Revenue Expense summary tab. look at d19. If you try to change those initials and hit enter you would get error signs. It seems to be okay now.
Can you check the page breaks and tell me how to consecutively number the pages?
thank you. Can you send the file back to me?