Data disappearing

[rcmii]

I thought I was a reasonably solid Excel user...but today I am having a small problem I cannot seem to resolve.

I have SUM's and when I hid the rows underneath those SUM's, the total in the SUM disappears. I thought it was formula based (SUMIF was the formula in the sub-rows), but when I hard-coded to values, the same thing happens.

Any thoughts on what I'm doing wrong? Is there an Excel feature that maybe I inadvertantly clicked on/off to make this happen?

Thanks.

RCM

 

[Ron Coderre]

Two questions:
1) Which version of Excel are you using?
2) Does the formula bar still display the cell contents?
... If yes...Maybe conditional formatting is engaged

 

[rcmii]

I am using Excel 2007...

I think I found the problem...the SUM's that I started with are now "SUBTOTAL" formulas. I never use SUBTOTAL so I'm not sure how those changed automatically.

The only other issue now is that when I "hide", but then click "unhide"...nothing selected actually "unhides".

 

[MrKowz]

Your data sounds like it is being autofiltered. Go to Data>Filter and see if there is a checkmark next to Autofilter

 

[rcmii]

I have solved all issues....thanks for your help.

Apparently, the brain is a little slow after working until 2am on some spreadsheets and thus missing even basic Excel thinking!

Thanks for your help.

 

[rcmii]

It was being auto-filtered...I had not used this workbook in months and had forgotten that I set it up that way. lack of sleep definitely impacts even the most basic memory on basic excel functions!

Thanks to everyone for your help.