Skip to main content

Lean Tools, Training, and Systems

Why use the Systems2win

Copy Sheet utility

Instead of the usual way to copy a sheet

Because it eliminates 5 Microsoft bugs

with the way that Microsoft Excel normally copies sheets

Bug #1 that gets eliminated

when you use the Systems2win Copy Sheet utility rather than Microsoft's usual Copy Sheet

If you are using a working document created from a Systems2win template that has a revision number lower than R140307 (a template created before March 7, 2014), then dropdown lists won't work on a copied sheet unless you use the special Systems2win Copy Sheet utility.

dropdown list

Dropdown lists are extremely valuable for faster data entry and elimination of typos. They are an essential component of any template that might benefit from Excel's Filter feature. Templates like the FMEA, Control Plan, Gantt Chart, To Do List, Training Matrix, and more.

Bug #2 that gets eliminated

when you use the Systems2win Copy Sheet utility rather than Microsoft's usual Copy Sheet

There are many named ranges that will get messed up if you copy your sheet without using the special Systems2win Copy Sheet utility.

Named ranges can be insidious. You might not notice at first that anything is amiss, until you attempt to use something that calls the named range, and then you wonder what happened (not realizing that your root problem was caused days ago when you copied your worksheet using Excel's usual way of copying sheets).

Bug #3 that gets eliminated

If you get a dialog box similar to this...

it is because you didn't use the Systems2win Copy Sheet utility

S2winFormula dialog

Bug #4 that gets eliminated

In some workbooks, your red/yellow/green Conditional Formatting might no longer work correctly if you copy a sheet without using the Systems2win Copy Sheet utility that eliminates Excel bugs.

Bug #5 that gets eliminated

when you use the Systems2win Copy Sheet utility rather than Microsoft's usual Copy Sheet

There is one more nasty bug that gets eliminated by using your Systems2win Copy Sheet utility, but just in case you're one of those do-it-yourselfers that enjoys Excel programming, we want you to experience the full joy to find and eliminate this one yourself.

Why re-invent?

Why re-invent?


tips

Tips for copying sheets

Use the special Systems2win Copy Sheet utility

Excel Ribbon bar > Systems2win tab > Copy Sheet

Learn more

Systems2win menu > Copy Sheet

Quick Fix if you forgot
to copy your sheet the right way

If you copied a sheet the wrong way, don't sweat. Just use this quick fix...

Save your document, then close and re-open Excel (not just the workbook, but all of Excel).

Then on the 'Help' sheet of your document, click the button to 'Open a blank Template sheet'. This will fix all of the other existing sheets.

You can then delete the extra new sheet if you don't need it.

Copying a worksheet to another workbook

Even using the Systems2win Copy Sheet utility...

copying a worksheet to another workbook can be less reliable.

Before copying sheets between workbooks, first close and re-open Excel.

If your copied workbook contains unwanted links to external sources, use Edit Links to redirect the links to your current workbook.

How to prevent most copy sheet bugs

Closing & re-opening Excel eliminates several bugs related to copying worksheets.

If you get in the habit of closing and re-opening Excel every time that you create a new workbook, and every time that you copy a worksheet, then you will eliminate most bugs related to copying sheets.

This is why most users never experience copy sheet bugs. They get interrupted, and end up unwittingly closing and re-opening Excel before they get around to copying their As Is worksheet to serve as the starting point for their Future State worksheet.