Forum Discussion

Panas_Wiwat-1964's avatar
Panas_Wiwat-1964
Copper Contributor
Jan 05, 2021
Solved

Data disappears from worksheets.

My excel sheet is acting weird.  I have multiple sheets linked together to perform sales and expenses analysis it all works out find when I open the file but once I enter a data on one of your worksh...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Jan 05, 2021

    Panas_Wiwat-1964 

     

    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's avatar
PanasW56
Copper Contributor
Jan 07, 2021

Riny_van_Eekelen 

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?

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 07, 2021

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?