Forum Discussion

tengeresz's avatar
tengeresz
Copper Contributor
Jun 23, 2021

excel reference copy problem

I have an excel file (original) with A and B sheets and a cell of B points to a cell of A.  When I try to copy the original sheet B to a new excel file the reference in the new B sheet cell contains ...
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jun 23, 2021

tengeresz 

for Excel for Microsoft 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007

Break a link to an external reference in Excel (Click for more Information)

Important: 

  • When you break a link to the source workbook of an external reference, all formulas that use the value in the source workbook are converted to their current values. For example, if you break the link to the external reference =SUM([Budget.xls]Annual!C10:C25), the SUM formula is replaced by the calculated value—whatever that may be. Also, because this action cannot be undone, you may want to save a version of the destination workbook as a backup.

  • If you use an external data range, a parameter in the query may be using data from another workbook. You may want to check for and remove any of these type of links.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

Resources