G
Guest
Good morning all.
I am copying a worksheet from an unsaved workfile to a saved excel sheet.
When I cut-paste-attach it to the saved workfile, excel is saving &
referencing the unsaved workfile formula's.
ie: =ROUND(SUM([Book4]Sheet1!AO6:[Book4]Sheet1!AO22),5)
When I delete Book4, I get #REF! errors in my saved file.
Is there a toggle to eliminate this error?
Thank you !
Jim Kimball
Hood River, OR
I am copying a worksheet from an unsaved workfile to a saved excel sheet.
When I cut-paste-attach it to the saved workfile, excel is saving &
referencing the unsaved workfile formula's.
ie: =ROUND(SUM([Book4]Sheet1!AO6:[Book4]Sheet1!AO22),5)
When I delete Book4, I get #REF! errors in my saved file.
Is there a toggle to eliminate this error?
Thank you !
Jim Kimball
Hood River, OR