Copied Worksheet, lost the lines that were drawn

  • Thread starter Thread starter Michael from Winnipeg
  • Start date Start date
M

Michael from Winnipeg

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 crashes on copying worksheet to new workbook 0
Copy Worksheet 1
Move/Copy Worksheet with Macros 2
Excel 2003 VBA problem - extracting and emailing worksheets 2
Move & Copy Problem, Limit? 3
Copying a worksheet to another workbook 6
Multiple worksheet Copy Paste Macro 2
Why do my arrows and shapes not print where placed in a worksheet? 1

Back
Top