unhidden columns keep hidden when opening file

R

Randy Lyle

When working in an Excel 2002 spreadsheet that had hidden columns. I unhide a
column and enter info into that column. I then save and exit Excel. Upon
opening of the spreadsheet again, that columns that I had unhidden are now
hidden again. This happens not every time, but ofter enough to be problem.
As a side note, the files all seem to be ones that were converted from Lotus.

Any help would be appreciated.
 
D

Dave Peterson

I've never seen this in xl2002. (But I don't have workbooks that were once
Lotus 123 files, either.)

Any chance you have a macro that adjusts the columnwidth?
 
R

Randy Lyle

No, there are no macros.

Dave Peterson said:
I've never seen this in xl2002. (But I don't have workbooks that were once
Lotus 123 files, either.)

Any chance you have a macro that adjusts the columnwidth?
Click to expand...
 
D

Dave Peterson

I don't have another guess.

Does this ever happen on a workbook that was created in xl?

If no, maybe it's time to consider rebuilding in excel???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Hidden column becoming unhidden upon forwarding 2
Help with conditionally unhiding columns 1
How to keep hidden columns hidden using protection 1
My rows keep "unhiding" when I do not want them to 6
Hidden Columns are unhidden when inserting a Formula 0
Cannot unhide the hidden rows in my spreadsheet 3
Column A is Off-screen (no, it's not hidden) 6

Top