Excel wants to update the values
sabdani
Posted messages
26
Status
Membre
-
Remi -
Remi -
Hello,
I have a little problem in Excel. I moved sheets containing formulas to another workbook. Of course, Excel extends my formulas to keep the link with the original workbook. I am using find/replace to remove this link from the formulas. This works very well for all my sheets except one, always the same one where when I click on replace all, Excel opens a "update values" window and apparently wants me to select a file to open. No matter how many times I click cancel or the close button in the upper right corner, this window keeps coming back and I don’t understand why. Does anyone have a miracle solution? (I'm using Excel 2007)
Thank you!!
Configuration: Windows 7 / Safari 535.1
I have a little problem in Excel. I moved sheets containing formulas to another workbook. Of course, Excel extends my formulas to keep the link with the original workbook. I am using find/replace to remove this link from the formulas. This works very well for all my sheets except one, always the same one where when I click on replace all, Excel opens a "update values" window and apparently wants me to select a file to open. No matter how many times I click cancel or the close button in the upper right corner, this window keeps coming back and I don’t understand why. Does anyone have a miracle solution? (I'm using Excel 2007)
Thank you!!
Configuration: Windows 7 / Safari 535.1
5 réponses
So I do indeed have a link to my old file. However, in this link window, I cannot delete it. I can only break the link, which I did, but then the link is still visible.
This did not solve the problem, but is it the wrong solution or is my link not really broken? I don't know... thank you for the help anyway.
This did not solve the problem, but is it the wrong solution or is my link not really broken? I don't know... thank you for the help anyway.
