Hi,
I have an annoying issue with a spreadsheet im trying to design. Basically, I have a table ( 5 colums by 30000ish rows) with data that is constantly changing and therefore constantly needs refreshing. downloading the data into the spreadsheet itself isn't a problem. However, I have formulas linking to this data that cause excel to slow down whenever ANY changes to the raw data i made, and the only formulas I'm using are sum and sumif. For example, here is what Im using:
sum(sumifs('Column E','Column A',"15",'Column B', "2","Column C","{'300','302','309','410','415','450','602','624','210','120',500','800','820','900'},'Column D', 'March'))
Formula works ok, just takes forever to work, even if only one cell in the table changes.
Does anyone have any ideas on how to fix this, even if it can be fixed?
And yes, i know about the manual way by going into excel options, but the whole point of this is so everything refreshes automatically.
Thanks,
Paul
I have an annoying issue with a spreadsheet im trying to design. Basically, I have a table ( 5 colums by 30000ish rows) with data that is constantly changing and therefore constantly needs refreshing. downloading the data into the spreadsheet itself isn't a problem. However, I have formulas linking to this data that cause excel to slow down whenever ANY changes to the raw data i made, and the only formulas I'm using are sum and sumif. For example, here is what Im using:
sum(sumifs('Column E','Column A',"15",'Column B', "2","Column C","{'300','302','309','410','415','450','602','624','210','120',500','800','820','900'},'Column D', 'March'))
Formula works ok, just takes forever to work, even if only one cell in the table changes.
Does anyone have any ideas on how to fix this, even if it can be fixed?
And yes, i know about the manual way by going into excel options, but the whole point of this is so everything refreshes automatically.
Thanks,
Paul
