External excel links not updating
Excel still updates the value of those cells depite me telling him not to in the prompt.I have tried to disable all external access in the trust center with no luck.
One of them is an icon which looks like a clipboard with numbers in the bottom left corner.may be quicker, however, if you have several links in your document because this method enables you to see a list of all links.On the other hand, you can also press Ctrl A to select everything in your document and then press F9.With manual links, Word updates the links only when you decide to update them. The simplest is to position the cursor somewhere in the linked object and then press F9.
The other is to choose Linked Worksheet Object - Links...
To create an external reference, execute the following steps.