Home — Continuous Improvement Tools
Process Improvement Tools.
Standard Work.
Work Instructions.
Flow Chart templates.
Swim Lane Cross Functional Flowchart.
Value Stream Mapping.
Lean tools.
Time Study templates.
DMAIC tools.
Quality Improvement tools.
House of Quality QFD.
FMEA Risk Reduction.
Root Cause Analysis tools.
Problem Solving tools.
OEE.
Preventive Maintenance.
Skip to main content
Installation and Setup
Installation - Each User. Installation - Multi-user. Language Translations. Personalize Your Templates.Systems2win Training.
Quick Start Initial Training. New User Training. Training Matrix. Systems2win Leadership. Training Classes.Lean Training
Lean 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.Microsoft Office Training
Excel Training. Excel Drawings (without Visio). Excel Charts. Word Training. PDF Training. Document Storage and Naming.Support
Support.Tips for choosing
Excel file formats
Caution: Never save a macro-enabled workbook as xlsx
If your workbook is already a (non-macro-enabled) .xlsx file,
then it is okay to keep it that way.
If your workbook has macros, then when Excel asks you to choose a file format, you can choose:
- Macro-Enabled Workbook (.xlsm)
- Binary Workbook (.xlsb)
- 97-2003 Workbook (.xls)
Do NOT choose the default Excel Workbook (.xlsx)
which will strip all macros!
Learn more about macros
How to change your default file format
As delivered from Microsoft, the default file format is .xlsx
(the one file format that you should never use, because it strips all macros)
To change your default file format...
File > Options > Save > Default Format
and then choose .xlsm, xlsb, or .xls
Compatibility
If different people in your work team use various versions of Microsoft Office
- then you will probably want to leave your working documents in Office 97-2003 Compatibility mode. (.xls)
Tip: The Compatibility Checker dialog often comes up with warnings that there will be "Significant Loss of Functionality" if you save your file in .xls Excel 97-2003 compatibility format. Most of these warnings are simply wrong. The functionality that might be lost is itemized, so you can test it for yourself, but you will find that there is usually no loss of functionality.
If everyone on your work team uses Office 2007 or higher
- then you might choose to save your working documents in one of the newer Excel file formats — both of which retain macros — with slightly improved performance, but with compromised backward compatibility:
- .xlsm, (macro enabled workbook), or...
- .xlsb (which has even more improved performance, but less backward compatibility)
Oops - I saved as xlsx
Now what do I do?
Option 1) Restore the deleted VBA
Open a fresh new blank template of the same type.
Copy the VBA module(s) from the new workbook to the damaged one.
Excel > ALT+F11 (to open Visual Basic for Applications)
Click the 'plus' symbol (+) to expand both workbooks so that you can see the modules in each.
Drag the M1Systems2win module to copy it from your undamaged workbook to the damaged one.
If there are additional missing modules, copy them too.
(Systems2win modules all start with the letter M)
Save the damaged workbook in a format that won't strip the macros.
(as described in the section at the top of this page)
Option 2) Migrate your data to a new workbook
Open a fresh new blank template of the same type.
Copy data from your damaged workbook, and paste it to the new one
using Paste Special > Values or Paste Special > Formulas
(not regular Paste) Learn more
