2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

A new workbook saved to a sharepoint is excruciatingly sluggish

I create a book1.xlsx and it's blank, save it to my desktop and it works as expected. Changing cells is instantaneous. Typing in a cell is instantaneous. Hitting enter to finish editing that cell is also instantaneous.

Then I save it to our organizations SharePoint, which happens to be overseas. Suddenly, every action is met with nearly half second lag. I can start typing in a cell at a normal speed and it lags, characters show up in chunks as I type. Even single-clicking on different cells is met with lag. This is in the desktop excel, not web based.

Why is this happening? Every online resource tells me I have too much data, too complex of a formula, but there is none of that in here. When I open an excel file from a sharepoint it's supposed to put it on my local machine, and then upload changes as I make them in the background. It's worked flawlessly for years. Now that this SharePoint is based overseas it becomes a sluggish nightmare from the get-go.

Is there something I can do to stop this behavior? Turning off autosave does not work.

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#generative AI for data analysis
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#big data management in spreadsheets
#machine learning in spreadsheet applications
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#SharePoint
#excel
#workbook
#lag
#desktop
#sluggish
#typing