Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying data from one workbook to another
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying data from one workbook to another
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 On Thu, 19 Jun 2008 10:12:02 -0700, Amber T <Amber wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 07: Copying data between tabs in a workbook (automatically) | Excel Discussion (Misc queries) | |||
copying data to different worksheets in the same workbook | Excel Worksheet Functions | |||
Copying data in a form into an alternative Workbook | Excel Discussion (Misc queries) | |||
Sorting and copying data to another worksheet in a workbook. | Excel Discussion (Misc queries) | |||
copying data from one workbook to another | Excel Discussion (Misc queries) |