Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PROBLESM IN COPYING BETWEEN WORKBOOKS AFTER EXCEL 2003 UPGRADE
GOOD DAY
MY COMPANY UPGRADED FROM OFFICE 2002 TO OFFICE 2003 LAST WEEK. PREVIOUS TO THE UPGRADE, I CREATED A SERIES OF WORKBOOKS IN EXCEL 2002. I HAVE SINCE RE-OPENED AND SAVED IN EXCEL 2003 CHANGES TO THE FIRST WORKBOOK IN THE SERIES. I FIND NOW THAT WHEN I TRY TO COPY EITHER DATA OR FORMULAS FROM WORKBOOK #1 TO WORKBOOK #2 IN THE SERIES, THE PASTE FUNCTION IS UNSHADED, BOTH IN THE DROP DOWN MENU AND ON THE TOOLBAR. I HAVE LOOKED AROUND IN THE TOOLS/OPTIONS MENU, BUT CANNOT SEEM TO FIND AN APPROPRIATE CHOICE TO CORRECT THE PROBLEM. ANY HELP WOULD BE APPRECIATED. THANK YOU |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PROBLESM IN COPYING BETWEEN WORKBOOKS AFTER EXCEL 2003 UPGRADE
Try clicking on the cell to copy and then copy from the F(x) box at top of
worksheet and paste into F(x) box in new worksheet to see if this works. You can use CNTL-C and CNTL-V to copy and paste. Paste will be Grayed Out if Windows did recognize that a Copy was made. It would be an interesting experiment to Paste the Data into a different Office product like Microsoft Word to see if the problem is with the copying or the Paste function. Also try to copy and paste from the 2003 workbook to the 2002 workbook. "JVorch" wrote: GOOD DAY MY COMPANY UPGRADED FROM OFFICE 2002 TO OFFICE 2003 LAST WEEK. PREVIOUS TO THE UPGRADE, I CREATED A SERIES OF WORKBOOKS IN EXCEL 2002. I HAVE SINCE RE-OPENED AND SAVED IN EXCEL 2003 CHANGES TO THE FIRST WORKBOOK IN THE SERIES. I FIND NOW THAT WHEN I TRY TO COPY EITHER DATA OR FORMULAS FROM WORKBOOK #1 TO WORKBOOK #2 IN THE SERIES, THE PASTE FUNCTION IS UNSHADED, BOTH IN THE DROP DOWN MENU AND ON THE TOOLBAR. I HAVE LOOKED AROUND IN THE TOOLS/OPTIONS MENU, BUT CANNOT SEEM TO FIND AN APPROPRIATE CHOICE TO CORRECT THE PROBLEM. ANY HELP WOULD BE APPRECIATED. THANK YOU |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
PROBLESM IN COPYING BETWEEN WORKBOOKS AFTER EXCEL 2003 UPGRADE
Please get your caps lock key repaired so that you can stop SHOUTING.
-- David Biddulph "JVorch" wrote in message ... GOOD DAY MY COMPANY UPGRADED FROM OFFICE 2002 TO OFFICE 2003 LAST WEEK. PREVIOUS TO THE UPGRADE, I CREATED A SERIES OF WORKBOOKS IN EXCEL 2002. I HAVE SINCE RE-OPENED AND SAVED IN EXCEL 2003 CHANGES TO THE FIRST WORKBOOK IN THE SERIES. I FIND NOW THAT WHEN I TRY TO COPY EITHER DATA OR FORMULAS FROM WORKBOOK #1 TO WORKBOOK #2 IN THE SERIES, THE PASTE FUNCTION IS UNSHADED, BOTH IN THE DROP DOWN MENU AND ON THE TOOLBAR. I HAVE LOOKED AROUND IN THE TOOLS/OPTIONS MENU, BUT CANNOT SEEM TO FIND AN APPROPRIATE CHOICE TO CORRECT THE PROBLEM. ANY HELP WOULD BE APPRECIATED. THANK YOU |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
PROBLESM IN COPYING BETWEEN WORKBOOKS AFTER EXCEL 2003 UPGRADE
Joel, thank you for your response. You put your finger on the problem, in
that I can copy the data into another MS application (Word), but cannot do so into another Excel workbook (within an individual workbook is fine). I tried to copy into the formula bar or use the Cntrl C command, and neither worked. Any other way to investigate the issue you can suggest? Thank you "JVorch" wrote: GOOD DAY MY COMPANY UPGRADED FROM OFFICE 2002 TO OFFICE 2003 LAST WEEK. PREVIOUS TO THE UPGRADE, I CREATED A SERIES OF WORKBOOKS IN EXCEL 2002. I HAVE SINCE RE-OPENED AND SAVED IN EXCEL 2003 CHANGES TO THE FIRST WORKBOOK IN THE SERIES. I FIND NOW THAT WHEN I TRY TO COPY EITHER DATA OR FORMULAS FROM WORKBOOK #1 TO WORKBOOK #2 IN THE SERIES, THE PASTE FUNCTION IS UNSHADED, BOTH IN THE DROP DOWN MENU AND ON THE TOOLBAR. I HAVE LOOKED AROUND IN THE TOOLS/OPTIONS MENU, BUT CANNOT SEEM TO FIND AN APPROPRIATE CHOICE TO CORRECT THE PROBLEM. ANY HELP WOULD BE APPRECIATED. THANK YOU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Upgrade to Excel 2003 -Will not print! | New Users to Excel | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
Excel 2003 upgrade - files truncated | Excel Discussion (Misc queries) | |||
Lost Excel 5 files after upgrade to Officel 2003 | Excel Discussion (Misc queries) | |||
Upgrade from Excel 97 to 2003 | Excel Discussion (Misc queries) |