Share via

Hidden Rows suddenly appear

Anonymous
2010-06-11T14:26:32+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

8 answers

Sort by: Most helpful
  1. Anonymous
    2010-06-11T17:23:50+00:00

    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 ?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2010-06-11T15:07:11+00:00

    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

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2010-06-11T15:03:46+00:00

    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?

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2010-06-11T14:42:26+00:00

    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

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2010-06-11T14:30:27+00:00

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

    Was this answer helpful?

    0 comments No comments