Cum Grano Salis

Excel Services Compatibility Checker: Build 914 - AutoFix external references + finer control over available checks

I uploaded version 914 onto the download page. This build adds two new features: Finer control over which features are available (and which are autofixed) as well as adding the ability to "fix" external references/RTD functions.

The ribbon changed a bit, it now has a "Settings" button (notice that I removed the checkbox I added in build 731):

image

When clicked, the user is presented with a dialog box for modifying the settings for the compatibility checker:

image

Each available feature-check the compatibility check can do is listed here, with two checkboxes. Only the features that have the left checkbox checked will actually run when analyzing a workbook. Of those executed, only the ones that have "Allow autofix" checked will actually attempt to autofix the problem.

To keep functionality the same, when you run the new version, the "Invalid Formulas" analysis (that's the thing that finds External References) does not have AutoFix turned on. Similarly, Invalid Character check is completely turned off.

Autofixing external references/RTD

Due to popular demand, the tool also knows how to fix External References and RTD functions. The way it does that is by checking what the value that resulted from the incompatible formula would have been and then just shoving that value into the cell/named range.

Published Friday, September 14, 2007 9:00 AM by Shahar

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Jim Puls said:

I loaded the checker on two completely separate systems. On one I see the new ribbon tab in Excel, but not on the other. On both the batch processor works fine. Is there a dependency I'm missing? Both systems are WinXP, and both are kept current with Microsoft Update. Any suggestions would be appreciated. Btw, the checker is great - just what I needed!

October 11, 2007 3:49 PM
 

Shahar said:

Can you check to see if the addin is registered at all? In the file menu, Options, Addins - you should see a list of all addins.

October 12, 2007 2:30 PM

Leave a Comment

(required) 
(optional)
(required) 

  
Enter Code Here: Required
Submit

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Microsoft
Page view tracker