May 23 2019 07:49 AM
With a source workbook containing all the latest prices, users create customized quotes. When opening a new quote file, the user select "update links" to get all the latest prices. But when he opens an old quote to compare, all opened quotes return to the old prices. How can the user open two excel files using the same source workbook but only have one updated and the other one not updated?
May 23 2019 09:37 AM
May 23 2019 02:58 PM
Thank you for the advice. Hum, the idea of linking the workbooks was that sales can update older quote if they wanted to continue with it. The prompt to update or not is great for that purpose. A formula with a timer at the top tells the salesperson when the quote is outdated and he can opt to update or keep. But after some time, a salesperson may want to create a new quote and compare it with the old obsolete one. For some reason, if the salesperson chooses not to update the old quote, the brand new which was updated, reverts to the old data. In other words, when the prompt to update or not update applies to every workbook opened on that computer and every workbook referenced. Is there a way to keep the source file update choice unique to each opened workbook?
May 23 2019 03:06 PM
I'm probably not explaining well. Source workbook A and B contain price tables regularly updated. Quote file C and quote file D source their prices from A and some other prices from B. Quote C is a year old and the salesman chooses not to update. Instead he opens a brand new Quote D and updates from A and B. But he wants to see what were the items quoted in file C last year, so he opens file C and chooses Not to update. (He also wants to see the price difference between last year and now). To his surprise, all the prices in Quote files D which were just updated, have reverted to year old prices from file C.
May 24 2019 05:23 AM
May 24 2019 09:17 AM
Thank you for the help.
However it really seems there is a bug in Excel. In the Edit Link box, I click on Startup prompt button and select "don't display the alert and don't update automatic link" and yet if I have another file open with the automatic update "on" and referring to a common source file, the first Excel file continues to update automatically.
May 24 2019 10:04 AM
SolutionMay 24 2019 10:04 AM
Solution