Copying data from one workbook to another

  • Thread starter Thread starter Amber T
  • Start date Start date
A

Amber T

I have a weird issue in Excel 2007

If I have two workbooks open. I choose the cell I want data to go to in
workboo1 so I put in "=" (without the quotes) in that cell. Then I go to
workbook2 and choose a cell that has data in it. I hit enter and nothing
happens. Usually it sort of highlights around the cell and when I hit enter
the data from workbook2 goes to the cell in workboob1. But that isn't
happening.

I had someone with the exact same issue, and they just kept trying it over
and over and it worked one time, then it stopped working again. What am i
missing?
 
Might be you have the two workbooks open in separate instances of Excel.

Close one instance and open both workbooks in one instance.


Gord Dibben MS Excel MVP
 
Back
Top