Break links

me2

Board Regular
Joined
Feb 1, 2005
Messages
112
I did a quick search but I didn't find anything that exactly answered my question.

I just wrote a macro that doesn't really do anything more than add a couple of columns of data with if statements and formats the whole thing to look pretty. It also moves the data sheet to a new file, names it, and saves it.

I would like to break the links to the orginal file so the new file stops asking me if I want to update the links.

What do I need to add to my macro to do that?

TIA,

me
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
How is the data moved to the new sheet?
Is it by copying and pasting or Paste Special>Values.....?
Care to post your code?
 

me2

Board Regular
Joined
Feb 1, 2005
Messages
112
moving the sheet

I move the whole sheet

Sheets("Data").Select
Sheets("Data").Move
 

Watch MrExcel Video

Forum statistics

Threads
1,113,810
Messages
5,544,425
Members
410,610
Latest member
renatha prado
Top