do not update not working on data link to another workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2088047%22%20slang%3D%22en-US%22%3Edo%20not%20update%20not%20working%20on%20data%20link%20to%20another%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2088047%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20is%20happening%3A%20I%20create%20a%20copy%20from%20an%20specific%20tab%20to%20a%20new%20workbook.%20On%20the%20original%20file%20there%20are%20many%20cells%20with%20formulas.%20I%20work%20with%20the%20new%20workbook%2C%20save%20it%20and%20close%20it.%20When%20I%20open%20it%20again%2C%20prompt%20appears%20%22do%20not%20update%22%20the%20values%20to%20the%20linked%20original%20file.%20I%20click%20%22don't%20update%22%2C%20but%20instead%20getting%20the%20values%20(since%20I%20clicked%20don't%20update)%2C%20excel%20brings%20me%20%23VALUE!.%20as%20if%20it%20was%20still%20trying%20to%20link%20to%20the%20original%20file.%20And%20even%20if%20I%20save%20the%20file%20to%20my%20Mac%2C%20I%20still%20get%20%23VALUE!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2088047%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

What is happening: I create a copy from an specific tab to a new workbook. On the original file there are many cells with formulas. I work with the new workbook, save it and close it. When I open it again, prompt appears "do not update" the values to the linked original file. I click "don't update", but instead getting the values (since I clicked don't update), excel brings me #VALUE!. as if it was still trying to link to the original file. And even if I save the file to my Mac, I still get #VALUE!

1 Reply

@Patriciamelo The duplicate tab might be referencing a formula name or tab from the original/closed workbook. It will be better if you can share the file, removing any sensitive data, to make it easier to find these references