Is this going to work: 68.000 linked cells in a model?

[dms11]

Hi all,
I have an excel model consisting of 68.000 cells with data. Basically it is an admin dashboard and central data collection (parent model). These cells are linked with 6 different excel models that are providing the data to the parent model and are in a cloud. The idea is that employees will enter/update information into the individual files and these should be directly updated in the parent model.

The setup is there but I have not yet inserted the date as it will come by and by over the next 6 months.
Question: is this going to work or am I going to run into major memory or other related problems?

Best

 

[dms11]

Hi Ford,
only the cells that have updated data need to be pulled in. So a macro that checks the cells for changes and would then pull in the data would be do a similarly good job, but I doubt that this would be a faster solution.
Koen: I havent worked with Access at all yet. I will check it out.
I have been working a lot with macros/VBA but my code for opening and copying the contents of each of the (feeding) files was not very fast and it had to flicker back and forth a lot between the master file and the feeding files.
Thanks

 

[Rijnsent]

Hi Best,

what you could do to speed macros up is to switch screenupdating and calculation off like so:
http://www.mrexcel.com/forum/excel-questions/845857-speed-up-macros.html#post4117189

Koen