ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copied Worksheet, lost the lines that were drawn (https://www.excelbanter.com/excel-discussion-misc-queries/261029-copied-worksheet-lost-lines-were-drawn.html)

Michael from Winnipeg

Copied Worksheet, lost the lines that were drawn
 
Recently upgraded to Windows7.

When I copy a Worksheet in the same Workbook (.xlsx file), the lines that
were drawn in the original Worksheet from the Insert/Illustrations/Shapes
from the Ribbon, do not copy to the new Worksheet.
I looked for something in the Options, but couldnt find an answer there.

Does anyone else have this problem as well, or know how to fix it?

Thanks,
Michael

Michael from Winnipeg

Copied Worksheet, lost the lines that were drawn
 
Found the solution.

When I re-set my Excel Options, in the Advanced tab/page, I checked off the
Cut, copy, and sort inserted objects with their parent cells.
I simply put the check back, and now a copied worksheet keeps the lines that
were drawn.

In case any one else comes across this problem, this is how you fix it.

Michael





"Michael from Winnipeg" wrote:

Recently upgraded to Windows7.

When I copy a Worksheet in the same Workbook (.xlsx file), the lines that
were drawn in the original Worksheet from the Insert/Illustrations/Shapes
from the Ribbon, do not copy to the new Worksheet.
I looked for something in the Options, but couldnt find an answer there.

Does anyone else have this problem as well, or know how to fix it?

Thanks,
Michael



All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com