Copy Excel 07 sheet to other & keep formulas? [Solved/Closed]

Report
-
 limitdydx -
Hello,
Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and keep the formulas in tact?

I can keep the formatting but the formulas and calculations always disappear.

4 replies

but while copying to another workbook, it does not keep the formulas, it just copied the values. In my case I want to retain the forumula as well.
Kindly suggest
56
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 5392 users have said thank you to us this month

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
789
quote
not another tab but completely different spreadshee
unquote
You mean to a different workbooks(file).

keep the file to which you want the sheet is to be copied, open

right click the sheet stab. click "move or copy"
in the move or copy window check "create a copy" at the bottom
go the to the arrow at the top next to "to book" window.
your other file name will be there. click it
you will be asked where do you want to copy after sheet1 etc or at the end
choose.
and click ok
this does not save the formulas
Move or copy works but the formulas will still point to the old worksheet(file)
Yes, I agree, how can you avoid the formulas poiting/linking to the old file?
after you paste to new sheet. go to Data Tab choose "edit link" then click "change source" , find the workbook you paste to.
Posts
1
Registration date
Thursday August 20, 2009
Status
Member
Last seen
August 22, 2009

Thank you for your reply. I was able to get it to work.
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
789
"window spreadsheet" what I thought was another excel spreadsheet either in the same file or another file