Easy way to copy entire workbook without resaving

derekpegg

Board Regular
Joined
Oct 7, 2005
Messages
145
My workbook has developed a 'DDE error' when I try to merge to Word. After having a look around this forum and M$ Support, it seems pretty fatal.

I was wondering if there is a (relatively) easy way to create a identical workbook by copying all the data out easily. I have about 50 sheets inc graphs etc. I guess that simply copying all the sheets out would mean the errors are transferred to the new file?

Any ideas? Thanks.
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
Looks like the "hard way" I am afraid. You will end up with a "clean" backup though.

Could try doing it bit by bit. Apart from the linked sheet, if you have any sheets containing controls from the Controls toolbar, start there.
 

derekpegg

Board Regular
Joined
Oct 7, 2005
Messages
145
Thanks Brian. I tried copying all sheets to a new workbook, but the DDE link problem remained. I have been pulling my hair out trying to think of a way around this and have now identified the offending sheet. I then spend some time copying and pasting the info out of this sheet into a new sheet, but still the problem remains. I am now thinking I will have to type all the fomulae in from scratch on this sheet, unless you know of a better way.
 

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
Don't think you actually have to type everything.
I usually start a new workbook and copy/paste formulas (includes values) then copy/paste formats. Then have to manually re-adjust column widths.
Need to add any named ranges though.
 

derekpegg

Board Regular
Joined
Oct 7, 2005
Messages
145
Thanks. I have done some more investigating and have narrowed it down to 12 named ranges on this sheet. I need to delete ALL 12 named ranges for it to establish the DDE link. The ranges are all OFFSET ranges and produce two charts on seperate tabs. Do you have any ideas on this? I think I will post a new thread after doing a quick search on this. Thanks again.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,910
Messages
5,574,989
Members
412,633
Latest member
simon_elvin
Top