• Announcements

    • xper

      MSFN Sponsorship and AdBlockers!   07/10/2016

      Dear members, MSFN is made available via subscriptions, donations and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, become a site sponsor and ads will be disabled automatically and by subscribing you get other sponsor benefits.
Sign in to follow this  
Followers 0
numms

Excel 2010 .xlsm Format Crashing.

1 post in this topic

I have an Excel Macro Enabled workbook that I've assembled with various links to other Excel files. It is a fairly large file used for compiling metrics from various data sources so there are a great number of formulas involved in the cells. I have placed some Grouping levels in columns to hide components of the calculated formula. For example, ScheduleAdherence%, which consists of ComplianceTime / ScheduledTime. For ease of maintaining this document, these three fields are populated in columns V, W, and X, and since the only metric we're going to be looking at daily is ScheduleAdherence%, I have columns W and X grouped on V. I feel this is a basic enough approach and seems to work for the purposes we need it for, HOWEVER... When using the number references in the upper left corner of Excel to expand and collapse the hidden columns, Excel consistently shuts down giving an error message. I have tried a number of different things to keep this from happening, but even directly after a successful save and reopening the document just saved, I still get this error message. Should anyone have any ideas which may help me out, I'd appreciate it very much. While doing them one at a time is fine, it's not what the program is designed to do.

Thanks in advance,

Andrew

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.