Forum Discussion
Solved
store linked values from template
I have an excel template used as a pricing tool. This workbook has links to a separate workbook where the prices are stored. When a user opens the template it updates the links to the pricing workbook. When the user saves the newly created file I want it to store the values. If that file is opened in the future I do not want it to update the linked prices. Can anyone tell me how to do this?
- This must be done manually (e.g. copy and the 'Paste as Values') or using a Macro doing basically the same thing. Another alternative would be to save as a .txt or .csv or similar and then re-import back into excel.
- This must be done manually (e.g. copy and the 'Paste as Values') or using a Macro doing basically the same thing. Another alternative would be to save as a .txt or .csv or similar and then re-import back into excel.
Darn. That's not what I wanted to hear. But thank you for your response.
