Microsoft Office Questions? Ask a IT Expert for Support ASAP
Try selecting the cell that has the formula, then click inside the Formula Bar and highlight the entire formula and copy it.
Then open the other workbook, select the cell that you want to paste the formula in, then click inside the Formula Bar and paste it there
Hope this helps. If I was able to answer your Question please go ahead and RATE this answer "Excellent" or "Good" so I get credit for my work.
Your question was not about 600 formulas. It was about copying the formula without a link
Now to automate the process so it can copy as many cells as you like you will need a macro created for that
No I think there is some misunderstanding here. If you were able to do that copy procedure in Excel 2003 you should be able to do the same in Excel 2010.
Could outline the steps that you did it in Excel 2003 so I can understand exactly what the issue is
No you must have different types of formulas in the two cases or the two workbooks are not opened from the same instance of Excel. If you can send me the file in which the copy procedure works in Excel 2003 I will show that it will work in Excel 2010 for the same formulas
And make sure you open both the source file and the destination files from the same instance of Excel (from within Excel using File > Open command and not by double clicking the file icons in your folder)
Again IT IS NOT AN EXCEL 2010 ISSUE. PERIOD
You are not willing to send me the file so I am not sure how else I can prove it to you
Have a great day
I will continue to assist if I can make sure I get credit for my time, and if the issue gets resolved you can add bonus later. Otherwise I will opt out to allow others to assist