Hidden rows reappear when opening the file.

[getravelman]

Numerous times, I've attempted to hide several rows in my file by performing the following steps ... highlight the appropriate rows, right-click one of the rows, select Hide, then save the file. Unfortunately, the next time I open the file, the hidden rows are once again displayed (unhidden). Is there a way to permanently hide the rows?

 

[rollis13]

The file is likely to contain a macro that shows the rows. What extension does the file have ?

 

[getravelman]

The file is likely to contain a macro that shows the rows. What extension does the file have ?

The wxte

 

[getravelman]

The wxte

The extension is xlsx.

 

[getravelman]

The wxte

My previous response was obviously a typo. Please ignore.

The extension of the file is xlsx.

 

[rollis13]

Oh, so there must be something wrong with your Excel installation unless you've activated some sort of add-in that resets the hidden rows. Sorry, but can't be of any other help in this case.

 

[getravelman]

Oh, so there must be something wrong with your Excel installation unless you've activated some sort of add-in that resets the hidden rows. Sorry, but can't be of any other help in this case.

This file was created back in 2014, so anything could have happened to the file since then. Anyway, thanks for trying. Greatly appreciated.

 

[Domenic]

First, if you haven't already done so, try quitting Excel altogether so that you don't have any workbooks open. Then try re-opening your workbook to see if the same thing happens. If so,
as @rollis13 has already suggested, disable any and all add-ins, and again see if you still have that issue. If so, here are a couple of other things to try...

Repair a corrupted workbook - Microsoft Support

Recover a corrupted workbook manually when Excel can't start File Recovery mode automatically and learn about saving backup and recovery files to prevent losing your work.

support.microsoft.com

Repair an Office application - Microsoft Support

Repair broken Office app installations.

support.microsoft.com

Hope this helps!

 

[getravelman]

First, if you haven't already done so, try quitting Excel altogether so that you don't have any workbooks open. Then try re-opening your workbook to see if the same thing happens. If so,
as @rollis13 has already suggested, disable any and all add-ins, and again see if you still have that issue. If so, here are a couple of other things to try...

Repair a corrupted workbook - Microsoft Support

Recover a corrupted workbook manually when Excel can't start File Recovery mode automatically and learn about saving backup and recovery files to prevent losing your work.

support.microsoft.com

Repair an Office application - Microsoft Support

Repair broken Office app installations.

support.microsoft.com

Hope this helps!

Domenic, thanks for the suggestions. I will give them a try and hopefully, will resolve my issue. Thanks again.