Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What exactly excel do when copying worksheets?
When I was copying some worksheets from one workbook to another, which
contains a lot of graphs. I found out that I can only copy 7 sheets with graph, the 8th one was copied but no graph was copied over. And if I save the workbook that I just added several sheets with graphs, I can't reopen it within the same excel. I have to close Excel and reopen another one to open it without causing serious error. My question is, what exactly excel does when I was copying worksheets from one workbook to another? Obviously it is clipboard. What else is happening? Thanks a lot! Jin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What exactly excel do when copying worksheets?
Here's a couple of long shots...
http://support.microsoft.com/?kbid=186219 XL97: Excel Quits Unexpectedly Running Macro That Creates Chart http://support.microsoft.com/kb/215573/en-us You receive an error message when you add a chart to a workbook in Excel -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Salut" wrote in message When I was copying some worksheets from one workbook to another, which contains a lot of graphs. I found out that I can only copy 7 sheets with graph, the 8th one was copied but no graph was copied over. And if I save the workbook that I just added several sheets with graphs, I can't reopen it within the same excel. I have to close Excel and reopen another one to open it without causing serious error. My question is, what exactly excel does when I was copying worksheets from one workbook to another? Obviously it is clipboard. What else is happening? Thanks a lot! Jin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What exactly excel do when copying worksheets?
Thanks for your suggestion.
But looks like it doesn't work for me. My Excel version is 2002. I tried to turn off the AutoCharFontScaling in Regedit. And also, in my Macro, I tune off the AutoScaleFont every time I made a copy of a worksheet which has Chart Objects. I still have the same problem. The first 7 worksheets are copied over perfectly fine. The last one is copied over without any Charts. And the bad thing is it doesn't give me any error message. Except that I can't open the workbook in Excel anymore. It can't even recover. I have to close my Excel and reopen Excel to open the workbook that I just created. At that time. I can copy the 8th worksheet with Charts to it without any problem. Any other possibilities? Thanks a lot! "Jim Cone" wrote: Here's a couple of long shots... http://support.microsoft.com/?kbid=186219 XL97: Excel Quits Unexpectedly Running Macro That Creates Chart http://support.microsoft.com/kb/215573/en-us You receive an error message when you add a chart to a workbook in Excel -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Salut" wrote in message When I was copying some worksheets from one workbook to another, which contains a lot of graphs. I found out that I can only copy 7 sheets with graph, the 8th one was copied but no graph was copied over. And if I save the workbook that I just added several sheets with graphs, I can't reopen it within the same excel. I have to close Excel and reopen another one to open it without causing serious error. My question is, what exactly excel does when I was copying worksheets from one workbook to another? Obviously it is clipboard. What else is happening? Thanks a lot! Jin |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What exactly excel do when copying worksheets?
Another weird thing is:
When I was trying to create a new sheet and use copy paste. Then the Charts are all copied into the new workbook without any problem. Now the new problem with the 8th worksheet is: Nothing is copied over except those Charts! Any hint? Thanks! "Salut" wrote: Thanks for your suggestion. But looks like it doesn't work for me. My Excel version is 2002. I tried to turn off the AutoCharFontScaling in Regedit. And also, in my Macro, I tune off the AutoScaleFont every time I made a copy of a worksheet which has Chart Objects. I still have the same problem. The first 7 worksheets are copied over perfectly fine. The last one is copied over without any Charts. And the bad thing is it doesn't give me any error message. Except that I can't open the workbook in Excel anymore. It can't even recover. I have to close my Excel and reopen Excel to open the workbook that I just created. At that time. I can copy the 8th worksheet with Charts to it without any problem. Any other possibilities? Thanks a lot! "Jim Cone" wrote: Here's a couple of long shots... http://support.microsoft.com/?kbid=186219 XL97: Excel Quits Unexpectedly Running Macro That Creates Chart http://support.microsoft.com/kb/215573/en-us You receive an error message when you add a chart to a workbook in Excel -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Salut" wrote in message When I was copying some worksheets from one workbook to another, which contains a lot of graphs. I found out that I can only copy 7 sheets with graph, the 8th one was copied but no graph was copied over. And if I save the workbook that I just added several sheets with graphs, I can't reopen it within the same excel. I have to close Excel and reopen another one to open it without causing serious error. My question is, what exactly excel does when I was copying worksheets from one workbook to another? Obviously it is clipboard. What else is happening? Thanks a lot! Jin |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
What exactly excel do when copying worksheets?
Two things... Do some searching in the Microsoft knowledge base for the problem. Try posting in the excel.charting group. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins: special sorting, comparing, matching, listing, finding...) "Salut" wrote in message Another weird thing is: When I was trying to create a new sheet and use copy paste. Then the Charts are all copied into the new workbook without any problem. Now the new problem with the 8th worksheet is: Nothing is copied over except those Charts! Any hint? Thanks! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
What exactly excel do when copying worksheets?
Thanks a lot! I will try to pose in Excel.Chart to see if I can get anything
from there. "Jim Cone" wrote: Two things... Do some searching in the Microsoft knowledge base for the problem. Try posting in the excel.charting group. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins: special sorting, comparing, matching, listing, finding...) "Salut" wrote in message Another weird thing is: When I was trying to create a new sheet and use copy paste. Then the Charts are all copied into the new workbook without any problem. Now the new problem with the 8th worksheet is: Nothing is copied over except those Charts! Any hint? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying worksheets into different Excel files | Excel Discussion (Misc queries) | |||
Copying Worksheets | Excel Worksheet Functions | |||
Excel 2003 - Copying formatting through 12 worksheets | Excel Discussion (Misc queries) | |||
Copying to other worksheets | Excel Discussion (Misc queries) | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) |