| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy from one file to another
In MS 2007 I cannot copy the contents of a cell in one workbook to a cell in
another workbook. There is no paste function when I go to the other workbook. It seems to be a problem with 2007. Does anyone else have this problem and is there a fix? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from one file to another
Hi Kim,
did you check if the workbook is not protected "Kim" wrote: In MS 2007 I cannot copy the contents of a cell in one workbook to a cell in another workbook. There is no paste function when I go to the other workbook. It seems to be a problem with 2007. Does anyone else have this problem and is there a fix? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from one file to another
No, not protected. Simple files, simple cells, multiple times with various
files. Does it work for you? "Eduardo" wrote: Hi Kim, did you check if the workbook is not protected "Kim" wrote: In MS 2007 I cannot copy the contents of a cell in one workbook to a cell in another workbook. There is no paste function when I go to the other workbook. It seems to be a problem with 2007. Does anyone else have this problem and is there a fix? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from one file to another
Frequently this is because the user has each file opened in a separate
instance of Excel. Try opening both files in the same Excel window. Kim wrote: In MS 2007 I cannot copy the contents of a cell in one workbook to a cell in another workbook. There is no paste function when I go to the other workbook. It seems to be a problem with 2007. Does anyone else have this problem and is there a fix? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from one file to another
Both files are in the same Excel window. Still no paste available.
"Bob I" wrote: Frequently this is because the user has each file opened in a separate instance of Excel. Try opening both files in the same Excel window. Kim wrote: In MS 2007 I cannot copy the contents of a cell in one workbook to a cell in another workbook. There is no paste function when I go to the other workbook. It seems to be a problem with 2007. Does anyone else have this problem and is there a fix? . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from one file to another
Open the Clipboard pane and observe whether something is there following
a Copy. Also there was some third party software that breaks Copy/Paste mentioned recently, do you have any add-ins? Kim wrote: Both files are in the same Excel window. Still no paste available. "Bob I" wrote: Frequently this is because the user has each file opened in a separate instance of Excel. Try opening both files in the same Excel window. Kim wrote: In MS 2007 I cannot copy the contents of a cell in one workbook to a cell in another workbook. There is no paste function when I go to the other workbook. It seems to be a problem with 2007. Does anyone else have this problem and is there a fix? . |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from one file to another
Hi Kim
Are then any macros in either of the workbooks, which could be disabling paste options? -- Regards Roger Govier Kim wrote: Both files are in the same Excel window. Still no paste available. "Bob I" wrote: Frequently this is because the user has each file opened in a separate instance of Excel. Try opening both files in the same Excel window. Kim wrote: In MS 2007 I cannot copy the contents of a cell in one workbook to a cell in another workbook. There is no paste function when I go to the other workbook. It seems to be a problem with 2007. Does anyone else have this problem and is there a fix? . |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from one file to another
It was on the clipboard and I can paste from there. Still no PasteSpecial
options, but this helps. Thank you! "Bob I" wrote: Open the Clipboard pane and observe whether something is there following a Copy. Also there was some third party software that breaks Copy/Paste mentioned recently, do you have any add-ins? Kim wrote: Both files are in the same Excel window. Still no paste available. "Bob I" wrote: Frequently this is because the user has each file opened in a separate instance of Excel. Try opening both files in the same Excel window. Kim wrote: In MS 2007 I cannot copy the contents of a cell in one workbook to a cell in another workbook. There is no paste function when I go to the other workbook. It seems to be a problem with 2007. Does anyone else have this problem and is there a fix? . . |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from one file to another
Is the "Paste" on the Home tab working? Is it only a single Worksheet
affected, or workbook, or any pair of workbooks? Kim wrote: It was on the clipboard and I can paste from there. Still no PasteSpecial options, but this helps. Thank you! "Bob I" wrote: Open the Clipboard pane and observe whether something is there following a Copy. Also there was some third party software that breaks Copy/Paste mentioned recently, do you have any add-ins? Kim wrote: Both files are in the same Excel window. Still no paste available. "Bob I" wrote: Frequently this is because the user has each file opened in a separate instance of Excel. Try opening both files in the same Excel window. Kim wrote: In MS 2007 I cannot copy the contents of a cell in one workbook to a cell in another workbook. There is no paste function when I go to the other workbook. It seems to be a problem with 2007. Does anyone else have this problem and is there a fix? . . |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from one file to another
There are no macros. It has happened on different files, on different days.
"Roger Govier" wrote: Hi Kim Are then any macros in either of the workbooks, which could be disabling paste options? -- Regards Roger Govier Kim wrote: Both files are in the same Excel window. Still no paste available. "Bob I" wrote: Frequently this is because the user has each file opened in a separate instance of Excel. Try opening both files in the same Excel window. Kim wrote: In MS 2007 I cannot copy the contents of a cell in one workbook to a cell in another workbook. There is no paste function when I go to the other workbook. It seems to be a problem with 2007. Does anyone else have this problem and is there a fix? . . |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from one file to another
The paste works fine between multiple sheets within the same workbook.
"Bob I" wrote: Is the "Paste" on the Home tab working? Is it only a single Worksheet affected, or workbook, or any pair of workbooks? Kim wrote: It was on the clipboard and I can paste from there. Still no PasteSpecial options, but this helps. Thank you! "Bob I" wrote: Open the Clipboard pane and observe whether something is there following a Copy. Also there was some third party software that breaks Copy/Paste mentioned recently, do you have any add-ins? Kim wrote: Both files are in the same Excel window. Still no paste available. "Bob I" wrote: Frequently this is because the user has each file opened in a separate instance of Excel. Try opening both files in the same Excel window. Kim wrote: In MS 2007 I cannot copy the contents of a cell in one workbook to a cell in another workbook. There is no paste function when I go to the other workbook. It seems to be a problem with 2007. Does anyone else have this problem and is there a fix? . . . |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy from one file to another
I've had instances of Copy/Paste fail, and only log off/log in gets it
working properly again. Kim wrote: The paste works fine between multiple sheets within the same workbook. "Bob I" wrote: Is the "Paste" on the Home tab working? Is it only a single Worksheet affected, or workbook, or any pair of workbooks? Kim wrote: It was on the clipboard and I can paste from there. Still no PasteSpecial options, but this helps. Thank you! "Bob I" wrote: Open the Clipboard pane and observe whether something is there following a Copy. Also there was some third party software that breaks Copy/Paste mentioned recently, do you have any add-ins? Kim wrote: Both files are in the same Excel window. Still no paste available. "Bob I" wrote: Frequently this is because the user has each file opened in a separate instance of Excel. Try opening both files in the same Excel window. Kim wrote: In MS 2007 I cannot copy the contents of a cell in one workbook to a cell in another workbook. There is no paste function when I go to the other workbook. It seems to be a problem with 2007. Does anyone else have this problem and is there a fix? . . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data for match word from one file to another file | Excel Worksheet Functions | |||
| How do I copy a excel file into a InDesign file correctly? | Excel Discussion (Misc queries) | |||
| copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
| copy/paste from one file to another without file name reference | Excel Discussion (Misc queries) | |||
Linear Mode
