File Size Excel

Nine Zero

Well-known Member
Joined
Mar 10, 2016
Messages
625
To All,

I have a .xlsx file which is currently 199KB

I found there was a formula in one of the sheets that was incorrect, so i fixed it and now when i save it grows to 13.5MB.......

The formula is not super complex, it is a simple SUM()....

What could be the issue?

EDIT:
It only happens if i choose to Update External Links...... which there are none of!!! anywhere!!!!!!!!!
 
Last edited:

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
It only happens if i choose to Update External Links...... which there are none of!!! anywhere!!!!!!!!!

If you even have the option to update external links, there is definitely at least one somewhere. (Otherwise the dialog is disabled.) You just haven't been able to find them yet...
 
Upvote 0

Forum statistics

Threads
1,224,830
Messages
6,181,229
Members
453,026
Latest member
cknader

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top