external links cause large file size

[MetLife]

Hi,

I have a workbook with only 3 formulas in cells D3, D4 and D5

Each formula is a SUMIFS

=SUMIFS('...\Datasets\PROD\[202312 NT INFORCE.csv]202312 NT INFORCE'!$BU:$BU,'...\PROD\[202312 NT INFORCE.csv]202312 NT INFORCE'!$G:$G,"CED",'...\Datasets\PROD\[202312 NT INFORCE.csv]202312 NT INFORCE'!$B:$B,"UL")

So when I save the workbook it is 2.5MB. Is there a way to reduce the workbook size? Other than pasting values?

 

[Dan_W]

That's all there is? What happens if you put those three formulas in a new workbook, and save that? It still comes to 2.5mb?

 

[MetLife]

That's all there is? What happens if you put those three formulas in a new workbook, and save that? It still comes to 2.5mb?

Yeah that seems to be the case.

Because pasted values make the workbook like 12KB

 

[Dan_W]

But 12kb is far less than 2.5mb.

 

[Alex Blakenburg]

I am about to lose my internet connection but you could try creating a pivot in the source sheet summarising by columns B & G and summing BU and run your sumifs or lookup against that.

 

[MetLife]

google says this creates large file sizes because it uses a snapshot of the data.

Is there any way around this?

 

[MetLife]

I am about to lose my internet connection but you could try creating a pivot in the source sheet summarising by columns B & G and summing BU and run your sumifs or lookup against that.

No unfortunately I can't change the source worksheet. It is handled by another group

I just need a way of getting that data

 

[Dan_W]

So another user here, JohnnyL, started to look into the issue of file bloat: Reducing workbook file size
He came up with a solution, which I then worked with him to help refine it : Alternative approach to fix those problematic excel files when excel sees 1048576 as the last row # & you can't fix it.

I doubt that it's the same issue as you're experiencing, but it can't hurt to check it out.