Excel Queries / Merge to New Document. 1

[postmanphat]

I have an Excel file that has a query embedded in it that takes data from an Access db. The problem is that I want to be able to send the xls to somebody else (who has no link to the Access db), and they are just going to get a load of error messages. Is there a way to save the spreadsheet so that it just saves a copy of the data as you see it without any links to the queries?

In MS Word, when you do a mail merge there is a button 'Merge to new document' which copies the mail merge into a standard Word doc without the links. This would solve my problem above - is there a similar function In Excel???

Thanks

Dave

PS I know I could copy the whole spreadsheet and do Paste Special and select to paste values, but it loses all the formatting on the spreadsheets (of which there is a lot!)

 

[GlennUK]

PS I know I could copy the whole spreadsheet and do Paste Special and select to paste values, but it loses all the formatting on the spreadsheets (of which there is a lot!)

Do Paste Values, and then straight after do Paste Formats.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[postmanphat]

Glenn - Give yourself a big pat on the back.