Keep columns hidden while writing formulas

[kclong]

I have a spreadsheet with hidden columns, say, columns B and C. When I write a formula is column D that points to column A, Excel will automatically unhide columns B and C while I'm writing the formula. How do I keep columns hidden while writing formulas? This has never been an issue before, and I can't seem to replicate it on other machines. It just started happending on my machine recently. I'm sure it's some setting I've turned on or off but can't figure it out. Anyone know?

 

[GlennUK]

What version of Excel are you using?

 

[kclong]

2003 SP3. Others in my office have the same version, which we have all been working the same for quite some time. But just recently my Excel started to have this issue with the hidden columns.

 

[GlennUK]

Sorry, but I can't recreate your error, and I tried quite a few settings being tweaked.

 

[xenou]

It's a strange one. Never heard of this before.
ξ