Google sheets to Excel
Hello all.
When saving a Google sheets doc to Excel all of the formulas that are referencing other tab values are giving me the #REF. The document converts fine in viewing / read only but as soon as I “enable editing” all of the values in boxes referencing other tabs change to #REF.
I reached out to Microsoft Office for help and they were unable to resolve my issue and referred me here.
Thank you in advance for any help!
Evan
Hello all.When saving a Google sheets doc to Excel all of the formulas that are referencing other tab values are giving me the #REF. The document converts fine in viewing / read only but as soon as I “enable editing” all of the values in boxes referencing other tabs change to #REF. I reached out to Microsoft Office for help and they were unable to resolve my issue and referred me here. Thank you in advance for any help!Evan Read More