Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Links to other files
I have approximately 100 spreadsheets that have the prices for items that are
linked to a master price list. Each spread sheet is set to allow you to open it without updating the links. The spread sheet will show if there has been any change to the price. If the spread sheet is opened without updating the links the price doesn't change. This configuration worked for 10 months without problems. Now if I open one spread sheet without updating the links the pricing doesn't change but if I open a second spread sheet (they are identical other than job specific information) without updating the links the prices are automatically being updated in the first spread sheet. Any ideas as to why the links are updating automatically even though it's configured to not update? |
#2
|
|||
|
|||
In xl2002+, you can specify how links should be handled per workbook.
Maybe one workbook has this setting turned on and the other turned off. Edit|links|Startup prompt === and you're absolutely positive that those links still point at the closed master workbook. If they point a workbook that's already opened, then they'll update. Eric wrote: I have approximately 100 spreadsheets that have the prices for items that are linked to a master price list. Each spread sheet is set to allow you to open it without updating the links. The spread sheet will show if there has been any change to the price. If the spread sheet is opened without updating the links the price doesn't change. This configuration worked for 10 months without problems. Now if I open one spread sheet without updating the links the pricing doesn't change but if I open a second spread sheet (they are identical other than job specific information) without updating the links the prices are automatically being updated in the first spread sheet. Any ideas as to why the links are updating automatically even though it's configured to not update? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want a window to cell data that conains links to PDF files and . | Excel Discussion (Misc queries) | |||
Update Individual Links | Excel Discussion (Misc queries) | |||
Problems opening Excel files using DFS links | Excel Discussion (Misc queries) | |||
multiple text files URGENT | Excel Discussion (Misc queries) | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |