Forum Discussion
Data disappears from worksheets.
Some of the cells on the Master sheet contain circular references: A3581 to A3589, and A3613/A3617.
Does the problem persist if you correct these by double-clicking the fill handle in A3, or by changing the formula in A2:A3925 to =ROW()-1 ?
PanasW56 Perhaps you can ask your friend to help you again to "clean-up" your sheets. But, I understand that removing the CF did speed up the sheet, but did not resolve the problem.
Attached workbook contains your data without formatting and two pivot tables to demonstrate what is possible. And this is just a very simple example.
Thanks. I am afraid she is not capable of doing the pivot table (she told me so). Is there anyway I can pay someone to set it up for me?
PanasW56 I'm affraid that working for money goes beyond the scope of this forum, but since you are comfortable with the sheet your friend made and you don't seem to have much experience with Excel, perhaps better to continue with the attached sheet. All conditional formatting removed from the Master file. On a Mac myself (not a very powerful one), added an entry att the bottom and it showed up without problems in the summary sheets. What kind of Mac ar you on?