Problem with formula referring to another sheet
Posted: Tue Jul 04, 2023 9:42 am
Hi Larsa,
if you try to enter a formula in a cell with a reference to another sheet (e.g. =Sheet1!C1), after typing the sheet name and pressing the ! key, the error message "Unknow sheet reference type: "00" appear.
Instead, if I enter the formula without the ! and add it after, then the formula works fine.
Can you help me?
Thank you very much!
Luigi
if you try to enter a formula in a cell with a reference to another sheet (e.g. =Sheet1!C1), after typing the sheet name and pressing the ! key, the error message "Unknow sheet reference type: "00" appear.
Instead, if I enter the formula without the ! and add it after, then the formula works fine.
Can you help me?
Thank you very much!
Luigi