Home

Charts Won't Update Under "ForceFullCalculation"

%3CLINGO-SUB%20id%3D%22lingo-sub-881735%22%20slang%3D%22en-US%22%3ECharts%20Won't%20Update%20Under%20%22ForceFullCalculation%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881735%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20face%3D%22Calibri%22%20color%3D%22%23000000%22%3EI%20had%20a%20~16MB%20Excel%20file%20that%20was%20loading%20slowly%20and%20performing%20poorly%20(~1%20minute%20to%20recover%20from%20a%20simple%20operation%20of%20unhiding%20rows%20that%20were%20%22Grouped%22).%20I%20found%20an%20article%20that%20suggested%20turning%20%22ForceFullCalculation%22%20to%20%22True%22%20in%20Visual%20Basic%20Workbook%20properties.%20I%20tried%20it%2C%20and%20performance%20dramatically%20improved%3B%20however%2C%20now%20charts%20won't%20update%20to%20reflect%20changes%20in%20tables%20feeding%20the%20charts.%20I%20spoke%20with%20MS%20Support%3A%20their%20Tier%202%20noted%20that%2C%20%22Force%20Full%20Calculation%20actually%20turns%20off%20features%20(like%20updates)%20to%20get%20processing%20power%22%2C%20and%20weren't%20able%20to%20provide%20any%20further%20assistance...but%20they%20did%26nbsp%3Bpoint%20me%20to%20this%20community.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22Calibri%22%20color%3D%22%23000000%22%3ECan%20anyone%20here%20help%3F%20I%20need%20the%20responsiveness%20that%20%22FFC%22%20brought%2C%20but%20I%20need%20my%20charts%20to%20update%20when%20changes%20are%20made%20to%20the%20underlying%20data.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-881735%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Cedric88
Regular Visitor

I had a ~16MB Excel file that was loading slowly and performing poorly (~1 minute to recover from a simple operation of unhiding rows that were "Grouped"). I found an article that suggested turning "ForceFullCalculation" to "True" in Visual Basic Workbook properties. I tried it, and performance dramatically improved; however, now charts won't update to reflect changes in tables feeding the charts. I spoke with MS Support: their Tier 2 noted that, "Force Full Calculation actually turns off features (like updates) to get processing power", and weren't able to provide any further assistance...but they did point me to this community.

 

Can anyone here help? I need the responsiveness that "FFC" brought, but I need my charts to update when changes are made to the underlying data.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies