Columns hiding automatically

Occasional Visitor



I have a huge complex spreadsheet shared with multiple users via Sharepoint.  I have columns and rows protected.  I have a few columns that are hiding themselves on their own.  I am able to unhide them again by unlocking the sheet, but they randomly hide again (sometimes not the same columns).  Some adjacent columns do contain formulas and there are some hidden columns nearby.  Has anyone else had a similar issue?




2 Replies
Does it help to set up a sheet view for this (View tab, on the left)?
I have the exact same issue, it's driving me nuts. Did you ever figure out the solution?