Excel spreadsheet connected to SQL server

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?