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

Linda - Aug 21, 2009 at 10:16 AM - Latest reply:  limitdydx
- Jan 13, 2013 at 01:14 AM
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.
See more 

8 replies

Best answer
56
Thank you
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

Thank you, boby 56

Something to say? Add comment

CCM has helped 1679 users this month

venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Aug 21, 2009 at 08:39 PM
20
Thank you
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.
lvoss 1 Posts Thursday August 20, 2009Registration date August 22, 2009 Last seen - Aug 22, 2009 at 01:55 PM
10
Thank you
Thank you for your reply. I was able to get it to work.
venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Feb 3, 2012 at 08:16 PM
0
Thank you
"window spreadsheet" what I thought was another excel spreadsheet either in the same file or another file