Break Link to spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel template that refreshes when the data file is overwritten but
need to stop refreshing once saved under another name for archive purpose.
How do you break the link with the data file once the work is over, so my
archived May report does not refresh once I update the data file with June
data...? Tks.
 
Hi
try copying the data and inserting it with 'Edit - Paste Special -
Values'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookups - how to obtain data from a master spreadsheet into another 5
Linked Excel File won't update 1
Refresh VBA 1
Link to Spreadsheet problem 3
Assigning names to a spreadsheet that updates 3
Refresh and run Excel macro 7
Break a link to a data source 3
Breaking the link 6

Back
Top