School project advice for improvement large excel data file.

Dear excel users,

A classmate and I are working project for are study analytical chemistry.
This project partly regards improving an excelfile which is used for data processing of an analytical technique (ICP-MS).
This is used for the analyisis of nanoparticles.
However the excelfile does does become quite heavy/large.
We have tried to improve the excel adapting several formula's and using macro's.
For example to store information as kind of "static information" instead of copying the calculation sheet multiple times,
in the hope make the file less heavy.

I wonder if you guys have any comments for improvement.

The excel file you can find on my onedrive link posted below. (I couldnt post the link because i am a new user of the forum hope to be able to post it in a message below)
-The non adapted version is called "old version"
-And the new version is a zip file called "final version" containing a xlsm and xlsx file

We do love to hear if you do have any advice.

Kind regards,
Bram

Thanks for your reply i will try to make a small version of the file.

Sory for my response before I was in a rush to get to the bus but still wanted to rapidly post it.

I tried to remove all non interesting sheets and data and saved them as .xlsb.
So hopefully they will work fine.


Kind regards,
Bram

maybe it will help a little:

Hello Sandy,

Thanks for your reply!
I did not know that Indirect() is a volatile function.

Do you have an alternative for this function?
I use:

Indirect(concatenate("column","rownumber) a lot to refer to a range till the last filled row in the column?

Kind regards,
Bram van de Kooi

maybe this:
https://stackoverflow.com/questions/...ve-to-indirect
or
https://www.mrexcel.com/forum/excel-...orksheets.html
or
Google

Thanks for your reply Sandy,

The alternatives in the links did not seem to work for me so I will try to find something on google.

Still thanks a lot,
Bram

You are welcome

maybe this one http://bfy.tw/HQgH