Forum Discussion
Doug_Short
Oct 03, 2023Copper Contributor
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 workboo...
- Oct 03, 2023This 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.
mtarler
Oct 03, 2023Silver Contributor
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.
- Doug_ShortOct 03, 2023Copper Contributor
Darn. That's not what I wanted to hear. But thank you for your response.