Home

Excel spreadsheet connected to SQL server

Kashu855
Occasional Contributor
I have an excel spreadsheet which is connected to SQL server and pull data from it to auto populate it in the spreadsheet.The problem is when i leave the excel file opne it’s size keeps on increasing and sometimes reaches upto 30GB and it also consumes too much of CPU resources which shows in the task manager. kindly suggest a fix for this
1 Reply
How many rows and columns of data is it pulling in ahnd how precisely?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 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
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies