Forum Discussion

Doug_Short's avatar
Doug_Short
Copper Contributor
Oct 03, 2023
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 workboo...
  • mtarler's avatar
    Oct 03, 2023
    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.

Resources