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
Frequent 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
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies