Known Issues

In other words, it takes you to the top of the help page, instead of directly to the part of the page that contains the help you're looking for.

2) Re-click the link (now that your browser is open)

• Tools > Share Workbook
• Tools > Track Changes
• Tools > Compare & Merge Workbooks

1) Don't open Excel documents through SharePoint.
Instead - open Excel first, and then open the document (on the SharePoint server) through Excel.

2) How to re-enable your Systems2win add-in

1. Any workbook is open to a worksheet named SampleHelp.
   
   Note: The purpose of greying out the menu options is to prevent you from accidentally deleting a SampleHelp worksheet. The problem is that the menu items are still greyed out for all worksheets on other workbooks if you have a any workbook open to a worksheet named SampleHelp.
   
   Solution:
   • Make sure no workbooks are open to a worksheet named SampleHelp.
2. Under unusual circumstances, the menu items can remain greyed out - even after your Systems2win template has been closed.
   
   Solution:
   • Download and use this FixRename file.
     Then upgrade your templates

Conditional formatting background colors don't work correctly in cells that have a clear background.

(Conditional formatting works correctly in cells that have a colored pattern background color)

We spent a lot of time working with Microsoft tech support on this issue, and they have decided not to produce a hotfix for this issue. However, they have decided to fix this bug in the next service pack, which will be Office 2010 service pack 1.

So while we're wating for them to fix it, we at Systems2win changed most of our templates to use white colored backgrounds (rather than clear) - and for those few templates that we decided to leave clear...
you could change the style of cells containing conditional formatting to a style that has a colored background patter (such as 2winWhite, which has a white background color), and perhaps apply a border.

Or you could edit conditional formatting to highlight cells using font colors or borders or something other than background color.

When copying an entire cell between worksheets, images often don't paste correctly.

They paste in a very collapsed format - so that they are invisible unless you use the Select Objects Arrow to highlight them.

On August 12, 2010, we released the bug fix for our Job Instructions template. You can simply download and install the free update.

If you run into this bug anywhere else, use the Select Objects Arrow to highlight the collapsed images, and then stretch them back to normal size.

If you experience any problems not itemized here - then updating to the latest Release Service Pack will often resolve the problem.

The user will usually just notice that "the charts don't work".

Office button > Excel Options button > Resources > Check for Updates

Also see video: How to make Office 2007 easier to use

Templates released after March 10, 2009 should no longer experience this known Microsoft bug.

As of March 2009, we have brought this to Microsoft's attention, and they have acknowledged it as a bug, but have not yet announced when it will be fixed.

Restart Excel to get your Add-ins menu tab back.

And to avoid this in the future - don't click Exit to get out of Print Preview. Instead, simply click any one of the other tabs in the Ribbon bar (such as the Home tab).

Textboxes containing formulas, (such as field labels in Standard Work and Job Instructions), don't automatically refresh.

For example, when you change data for a field label on the VC worksheet, it should automatically update every textbox on every worksheet that has a linked formula

The first time that you change data for a field label (usually on the VC worksheet), you must go to each textbox with a formula linked to that cell - and in the formula bar, place your cursor at the end of the formula - and press the Enter key.

After doing this once, from then on the formula in the textbox will automatically refresh just the way it used to in Excel 2003. (before Microsoft "improved" it)

Charts on the Gantt Chart and Standard Work sometimes need to be manually re-aligned.

This is a Microsoft bug that we can't fix programmatically on our end... and is pretty easy for a human being to make the "mental shift" to correlate the correct header with the next column over.

If it really bothers you, on any given Filter worksheet that has already been generated by clicking the Generate Filtered Worksheet button... you can manually change all the chart data ranges to exclude the horizontal thin gold lines.

This will remove the problem for the one Filter worksheet containing known data - but would mess up your ability to create new Filter sheets if you were to do this on your master OEEFilter worksheet.

Some day Microsoft will simply release an update that resolves this bug, and it will magically work like it does in Excel 2003.

When using Systems2win version 6 or lower
in SOME installations of Office 2007 (rare)

Opening the StdWork template, the Sys2win_ST.sys file fails to open under the following conditions:

• the Sample worksheet is active
• the workbook is opened using File > New or Systems2win menu > Open a New Template
  (see optional ways to find & open your Systems2win templates)

There are several work-arounds for this (highly unusual) bug that only affects StdWork:

1. Upgrade your Systems2win templates. (This is no longer an issue in v7)
2. Save your master template opened to a worksheet other than Sample. (As of Aug 1, 2008, we started shipping StdWork opened to the Help worksheet).
3. Open StdWork using one of the other optional ways to find & open your Systems2win templates.
4. If you get the error that the Sys2win_ST.sys file cannot be opened, just save your working document, and re-open it. The error will be gone.

If you experience any problems not itemized here - then updating to the latest Release Service Pack will often resolve the problem.

Data validation drop-down lists on a copied worksheet   (Excel 2003 and lower)

Templates affected: Any Systems2win template that has a DV (Data Validation) worksheet - running on Excel 2003 or lower.

Symptoms: Data validation drop-down lists don't work on a copied worksheet.

Understanding the underlying problem: This is a pure & simple Microsoft bug. When you copy a worksheet in the usual recommended way, Excel 2003 and lower (incorrectly) creates a new local named range (rather than using the global named range like it should).

Excel 4.0 macro dialog

For some templates released prior to December 2006, when you open the template in Excel 2003 or higher, you might get the error message (above).

If you select "No", then you will disable the conditional formatting to highlight cells containing formulas. This is a  very useful feature, so we suggest to select "yes" to enable the Excel 4.0 macros.

In November 2006, this functionality was replaced with a version that no longer gives the above warning message, and with version 5+ we provided a second optional way to highlight cells containing formulas. Yet another reason to keep your templates upgraded.

This features was not introduced until Excel 2003, so you need to choose one date format, and stick with it.

If you experience any problems not itemized here - then updating to the latest Release Service Pack will often resolve the problem.

Be sure that you have configured Windows Update to also check for Microsoft Office updates (not just Windows updates)

The following templates require Excel 2002 or higher:

• Decision PICK Matrix
• Job Instructions
• Pareto Chart
• Supply Chain Value Stream Map

For an extra fee, the following templates can be delivered in a special format that fully supports Excel 2000:

• Cause and Effect Matrix
• Machine Balancing
• QFD House of Quality
• Results Metrics

With the special Excel 2000 version, the following templates can be viewed and shared with users in Excel 2000 - but most editing should be done by a more advanced user - in a higher version of Excel:

• Functional Flowchart
  (Excel 2000 users can draw flowcharts - but lean metrics should be edited in a higher version)
• Gantt Chart
• Standard Work Combination Sheet
• Value Stream Mapping - PowerTool

Reminder: The VSM-Simple template doesn't have all the sophisticated lean metrics of the PowerTool, but is fully compatible with Excel 2000

1. You can use the org chart templates as a starting point to draw and format your org chart or tree diagram without benefit of the advanced organization chart toolbar.
2. Use Excel 2002 or 2003 for these (rarely-used) tasks.

1. To overcome this limitation, Systems2win has provided a palette of shapes in rotated positions (for those shapes most commonly needed to be rotated).
2. Use a higher version of Excel to rotate shapes, then re-open the same file in your lower version of Excel and continue editing.

1. Use a higher version of Excel to save your template with rows and/or columns already appropriately hidden or unhidden - so that the template is ready to use for a typical process in your company.
2. Open the workbook in a higher version of Excel to insert, resize, hide, or unhide.

(You can then re-open the same worksheet in the lower version of Excel and continue doing the 99% of things that Excel 2000 can do)

Open the workbook in a higher version of Excel to insert the hyperlinks.

(You can then re-open the same worksheet in the lower version of Excel and continue doing the 99% of things that Excel 2000 can do)

This only happens if Word > Tools > Options > View > Windows in Taskbar is enabled, (and it usually is).

For older versions, use one of the other Alternative ways to find and open your Systems2win templates