Skip to main content
D
dthati1-Visitor
1-Visitor
November 19, 2015
Question

Why would the file size drastically increase?

  • November 19, 2015
  • 3 replies
  • 1655 views


Why would the file size drastically increase when an excel component is added?

Thanks for the help.

3 replies

R
RichardJ19-Tanzanite
19-Tanzanite
November 19, 2015

Because the Excel spreadsheet is embedded, not linked. Everything in the Excel spreadsheet is in the Mathcad file. Object Linking and Embedding (OLE) allows an object to be either linked (referenced) or embedded. When you create an Excel object in Mathcad it is embedded. Unfortunately, Mathcad does not provide the option of linking.

V
VladimirN24-Ruby III
24-Ruby III
November 20, 2015

And how much has increased the size of the file with the Excel component and without it?

S
StuartBruff23-Emerald V
23-Emerald V
November 20, 2015

Deepthi Thati wrote:


Why would the file size drastically increase when an excel component is added?

Is this an issue for you or just a curiosity question?  If it's an issue, can you work round the problem by using the READEXCEL and WRITEEXCEL functions instead (they should only cause a very small increase in file size)?

Stuart

D
dthati1-VisitorAuthor
1-Visitor
November 24, 2015

Thank you very much for all the responses. I am using an excel component to create input/output summary tables and graphs and for that I do not have to READ or WRITE excel.

When I created an excel table in Mathcad the size of the file was increased by 8 to 10 MB. Somehow in one of my programs, I could able to figure it out that the file size is increasing due to a corrupted excel table and I fixed it. But I still have one more program, the file size increased to 52MB from 9MB after adding 6 excel tables in the program. I will try to check that by recreating the tables in the program.

Thanks,

Deepthi

R
RichardJ19-Tanzanite
19-Tanzanite
November 24, 2015

Are you saving in .xmcd or .xmcdz format? The .xmcd format is very bloated, whereas the .xmcdz format is compressed (in fact, it is a zipped .xmcd file). You can change the default format under "tools", "preferences".

Terms & ConditionsAccessibility statement