View Single Post
  #3   Report Post  
Big Andy D
 
Posts: n/a
Default

My apologies ... typo ... entering a "formula" into a cell.

I'll get the user to try it tomorrow but it appears to happen on any
spreadsheet she works on. No macros involved - I'll check her personal.xls.
I agree about it being unusual ... I've never seen it before and I cannot
recreate in on any other PC.

Any thoughts?

"Jim Rech" wrote:

I'm not sure what you mean by "entering a column into any cell" but columns
unhiding themselves is pretty unusual. Can a macro be involved (perhaps
unknowingly)? If you disable macros when you open the workbook does the
problem still occur? If so, when you start Excel in safe mode so that no
extra files are opened (Start-Run and enter "Excel.exe /s" without quotes)
does it happen?.

--
Jim
"Big Andy D" <Big Andy wrote in message
...
| Background:
| Spreadsheet contains many ranges of hidden columns.
|
| Problem:
| When manually (i.e. no macro involved) entering a column into any cell,
all
| hidden columns unhide - causing much frustration to the user concerned.
|
| This problem is local to one user and their PC. This would suggest that
| this is an Excel setting ... but I can't find it for the life of me !!
|
| Please help !!