Solved breaking a link between workbooks in excel

July 25, 2015 at 03:39:13
Specs: Windows 7
hello guys,

I am made a pivot table in one workbook but copied part of the data from another workbook.
Now every time i open the workbook with the pivot table there appears a pop up saying that there is a connection between the source data en mine workbook. Can somebody help me to break this link.
Thank you in advance

See More: breaking a link between workbooks in excel

Report •

July 25, 2015 at 04:55:17
I had a similar issue before. I deleted the pivot table and established the appropriate data boundaries with a NEW pivot table. Your data should not be altered.

Don C

Report •

July 25, 2015 at 09:01:21
thank you don for your reply i tried what you advise but it stil show the pop up that says:
this workbook contains links to other data sources if you update the link excel will attempt to retrieve the latest data an so on.
='G:\equity strategy\[exam august 2004 hh.xls]Sheet1'!F69
='G:\equity strategy\[exam august 2004 hh.xls]Sheet1'!F70
='G:\equity strategy\[exam august 2004 hh.xls]Sheet1'!F71
='G:\equity strategy\[exam august 2004 hh.xls]Sheet1'!F72
='G:\equity strategy\[exam august 2004 hh.xls]Sheet1'!F73
='G:\equity strategy\[exam august 2004 hh.xls]Sheet1'!F74
='G:\equity strategy\[exam august 2004 hh.xls]Sheet1'!F75
='G:\equity strategy\[exam august 2004 hh.xls]Sheet1'!F76
='G:\equity strategy\[exam august 2004 hh.xls]Sheet1'!F77

this is what you see

message edited by debi110

Report •

July 25, 2015 at 09:32:51
✔ Best Answer
See if this link offers any assistance:


Report •

Related Solutions

July 25, 2015 at 09:41:09
excellent mike thank you for the link!

Report •

Ask Question