←Back to Beyond Market Intelligence
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Font formatting of a calculation dashboard KEEPS reverting every time the data in the other sheets is updated

Our take

Are you frustrated with your calculation dashboard’s font formatting reverting every time you update data? Many users face similar challenges, especially when striving for readability for low-tech team members. Despite creating a custom cell style, the formatting resets to Calibri size 11, prompting questions about the feasibility of maintaining consistent formatting in a dynamic spreadsheet environment. If your spreadsheet is stored on SharePoint, it may contribute to this issue.

I am at my wits end, every time I open this spreadsheet the formatting of these cells (supposed to be large and extremely readable to low-tech users on same team) reverts back to Calibri size 11 for some reason. I even created a custom cell style to try and force it to stay that way and I can see that it's selected in the menu, but not reflected whatsoever.

Is it just impossible to format cells with a constantly changing calculation? What can I do here?? I feel like I have gone through every formatting constraint/rule there is to try and force it to behave but it always changes back, even if its not right away.

It's a spreadsheet stored on sharepoint primarily but I don't know if that makes a difference. Advice appreciated. 😞

submitted by /u/vailette
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#real-time data collaboration#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#generative AI for data analysis#rows.com#real-time collaboration#natural language processing for spreadsheets#Excel compatibility#large dataset processing#financial modeling with spreadsheets