problem copying formula from one workbook to another

L

letyuknow

Background:

I am on Window 2000, Excel 2000 ver 9.0 SP3

I copied a cell in one workbook that has formula (=C14/M15) and try to
paste to another workbook. Excel paste the value instead of formula.
When I use paste special, it identify the cell as worksheet object
instead of the usual dialog of choices such as value, formula. If I
just want to copy one cell, I can just copy from the formula bar.
However, I need to copy a range of cells have different formulas. Is
it caused by some setting of my excel or is it because I have a pivot
table on the original worksheet and the formula reference cells in
pivot table? Any good idea to accomplish this?

Thanks in advance,
Jason
 
D

Dave Peterson

You are running two instances of excel.

Close one workbook (and that instance of excel).

In the other instance, use File|open and open the second file.

Then try your copy|paste.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use Macro to Copy Formula from one Workbook to another 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copying Formulas from Workbook to Workbook 3
Copy formulas to another workbook 4
Odd Formula copying Behavior 3
copying a formula 1
Copying linked sheet 2
Copy formula from one workbook to another without reference to 1st 4

Top