Forum Discussion
use a formula that links to another worksheet and that worksheet will clear contents causing ref err
0
Thank you I'm I cannot attach document because it's sensitive information but I will try to explain I have 2 work sheets a calc sheet and a data sheet.
I import data into the data sheetand then run a macro from the calc sheet.
I have a clear button that reset the sheet
Some of formulas from the calc sheet that pull from the data have a ref error
Sumif function point to a range t:t the t:t becomes a ref error
I import data into the data sheetand then run a macro from the calc sheet.
I have a clear button that reset the sheet
Some of formulas from the calc sheet that pull from the data have a ref error
Sumif function point to a range t:t the t:t becomes a ref error
So wird ein #BEZUG!-Fehler korrigiert (in German)
https://support.microsoft.com/de-de/office/so-wird-ein-bezug-fehler-korrigiert-822c8e46-e610-4d02-bf29-ec4b8c5ff4be
How to correct a #REF! error (in English)
https://support.microsoft.com/en-gb/office/how-to-correct-a-ref-error-822c8e46-e610-4d02-bf29-ec4b8c5ff4be?ui=en-us&rs=en-gb&ad=gb
Theoretically, you could work around the problem by not writing the corresponding calculation formulas in the cells, but in VB code (macro recorder).
You can then insert this code into the "Worksheet Activate" event of Sheet1, for example.
This will restore the formula every time Sheet1 is activated.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)