conditioned calculation mode?

[yoniman]

Dear all
The story: I wish a sheet to be prepared for large data intake over months and perhaps years of follow-up.
the problem: currently I use less than 10% of the cell which already contain functions so the file is >50MB in size for no actual reason (unfortunately I must use Match() or Find() functions).
please assume I tried it all including the kind assistance of the forum.

wishful solution: Can I form a semi "Calculation options-->Manual" mode? i.e. to condition the cell calculation on (for example) certain Isblank(cell)=false?

I'm not optimistic and would love it if someone can surprise me

[TMS]

I have a similar situation where I am working.

My personal preference is to delete the "pre-populated" rows and convert the "live" data to an Excel List. When you add rows, it will automatically copy the formula(e) into the new row.

Note that, AFAIK, the List mode will not work in a Protected worksheet.

In that event, I'd consider monitoring the workbook on a weekly, or even daily, basis and adding a block of pre-formatted rows. The requirement can be calculated on a historical basis ... if it took 20 weeks to create 2000 rows, you're adding, on average, 100 rows a week.

If the formulae in the "old" rows do not need to be recalculated, you can copy and paste special values to reduce the calculation overhead. There might be a compromise here if some need to calculate and others don't.

Another alternative is to use a Worksheet Change event to monitor data additions and add formulae into the row as and when needed.

Lot's of considerations :-)

Hope this helps, or at least gives you some food for thought.

Regards

[yoniman]

appreciate the attempt and I will take your word that this cannot be done.
too bad