Hidden Rows suddenly appear

Question

I am preparing a budget workbook and have worksheets (tabs) for various departments in our company.  I want the line items to be in the exact same rows in each worksheet so that I can sum across the worksheets easily.  That works fine. 

However, I hide various rows since some departments don't all have the same types of expenses.  Problem is that I find after I save and close the file and then reopen it later, that the hidden rows re-appear.  I don't want them to re-appear.  What is causing this.

Answer 1

I just discovered that it is still unhiding even when I don't close and reopen the file.   Could it have anything to do with Summing numbers across multiple pages in an Excel file ?

Answer 2

In that case you could be saving it as and XLSX but opening it as an XLS - hense you are really working with two different files.  XLSX is the new 2007 file extension, xls is the older one. 

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

Answer 3

Yes, I could be saving the file from one location and opening it from another location.

Could it be because I am working in Excel 2007 but saving it in the 2003 format?

Answer 4

There is no option you can set to do this in Excel, it must be a macro or something in the description is missing.  Are you on the same sheet when you close the file as the one where the rows are hidden?  Could you be saving the file to one location and opening it from another?

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

Answer 5

Perhaps there is a macro that runs when the workbook is opened that unhides the rows.