eyecare

New Member
I have 2 workbooks that are the same for 2 different accounts. I do my development work in workbook #1 and then I copied the new sheet from workbook #1 to workbook #2. Now when I open workbook #1 I get the following message.

The workbook you opened containes automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook. ..... YES ..... NO

The sheet that I copied over did have formulas in some cells, only relating to other cells on the same sheet. How can I un-link these 2 books

Would appreciate some help on this.

Thank You: Gene Gould OD

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
welcome to the board

First you need to find the linked cells

by either copying the cell then pasting value(this way there will no longer be a formula in the cell)

or to fix the formula so its no longer a link

=(('[test.xls]R PLAN'!K11*35%)*1.08)*'[test.xls]PLANS'!\$AW\$1

=(('R PLAN'!K11*35%)*1.08)*PLANS!\$AW\$1

this is the line creating a link
[test.xls]

hope this helps
steve w
This message was edited by white6174 on 2002-09-08 11:44

Replies
0
Views
123
Replies
3
Views
130
Replies
2
Views
232
Replies
0
Views
141
Replies
8
Views
486

1,221,521
Messages
6,160,302
Members
451,637
Latest member
hvp2262

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back