Installation and SetupInstallation - Each User Installation - Multi-user Language Translations Personalize Your Templates
Systems2win TrainingQuick Start Initial Training New User Training Training Matrix Systems2win Leadership Training Classes
Lean TrainingLean Training and Coaching Lean Principles Muda 8 Wastes Goal - Lean Flow Roadmap - Lean Journey Value Stream Mapping Standard Work Hansei Lean Thinking Lean Dictionary Online Lean Training Lean Leadership
CustomersOperational Excellence Lean Manufacturing Lean Office and Service Lean Healthcare Customer List
to transfer data from an old working document to a new template
Option 1) Don't
Most old working documents work fine without doing anything
Simply continue using your working document as it is.
Any new working documents that you create will start out with the foundation of your new template, but you will usually just keeping using your old working documents as they are (with the underlying base foundation of the older template).
Simple documents can be used even without the Legacy Compatibility Installer
Working documents created from simple legacy templates will work just fine even without the Legacy Compatibility Installer, which is needed only for more complex templates that have unique functions or macros.
If you see #NAME errors, then that means that you need to either:
(following the instructions in the section below)
When to install the Legacy Compatibility Installer
If you know that a user will need to use legacy documents created from a complex template version 10 or older...
then the Legacy Compatibility Installer should be installed for that user which will enable that user to use legacy documents (version 10 or older) without migrating data from the old working document to your new template.
You don't NEED to migrate data from an old working document to a new template, but you might WANT to:
Tip: Because it has been so many years since version 11 was released in March 2013...
now is probably a good time to consult with Systems2win to come up with a plan to efficiently migrate data from any old working documents created using complex templates v10 or lower.
Once your data has been migrated, then none of your users will need Legacy Compatibility.
You NEED to migrate data:
from an old working document to a new template
Open both the old (source) and new (destination) workbooks
Tip: To open a really old working document created using a legacy template version 8 or lower, use Systems2win menu > Setup > Open a Legacy Document
(which bypasses the legacy security features that were discontinued in v9)
This will open the document, but you might still need to migrate your data to a new template in order for macros and functions to work in documents created from a very old complex template.
Unhide any hidden rows or columns
on both the source and destination worksheets.
Copy data from the old document
using simple copy CTRL+C
Paste to the new document
Simple paste CTRL+V will work if (and only if)...
the source and destination color schemes, styles, formulas, data validation, cell comments, conditional formatting, and other hidden elements are all identical.
Because hidden formulas and formatting are often not identical...
you will usually use Paste Special > Formulas,
or Paste Special > Values
To copy shapes...
be sure that the source and destination sheets
have the same number of columns, all columns are unhidden, and column widths are identical
Tip: Paste Special > Column Widths can be helpful
Tip: The Select Objects Arrow makes it easy to select shapes to copy
Our IT Department didn't know
it was possible to have
for Excel templates
Systems2win has systems
for that, too?