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 ?
Panas_Wiwat-1964 I see. Tested your sheet again and noticed that the sheet doesn't calculate automatically, even when "auto calculation" is switched on. Copied all formulae from row 12 down and everything calculates instantly. Saved the file, closed it and reopened it. Now, when I add a row with data, the sheet calculates properly. Can't really explain why this happens, but I notice that your sheet has serious performance problems. But that's perhaps only an issue on less powerful systems (like my MB Air). And just trying to "play-around" with all the conditional formats hangs-up my Excel instantly.
Perhaps you need to consider collecting your transactional data without too much fancy formatting and use Pivot Tables to summarise it. You can achieve more-or-less the same results, cutting down on the file size and number of calculations and increasing performance considerably.
How do I do that? A friend of mine created the whole worksheet for me. I know nothing about creating conditional formatting.
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?
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 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.