Easy way to copy entire workbook without resaving

[derekpegg]

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.

 

[BrianB]

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]

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]

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]

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.