One file with multiple sheets or split data into some files ¿Wich option is better?

Hi everyone

I have a theoretical question and I hope you can give me some advice about it.

I have one file with some sheets with schedule data, one for each worker, and then 4 with the summary data for each department. I make all the calculations with VBA and put the data at the summary shet.

It works fine, but now I try to optimize the code and I find some opposite answer on the Internet. Is better keep all data at the same file (even if that means have 50 sheets), or is more efficient to separate data from each people into one file and summary sheets into another?.

At the internet there are some people saying is better to have all data at the same file (avoiding the time and problems to access other files) and others that are better split it into some files to sepparte calculations and reduce RAM usage.

Any advice will be welcome.

Thank you.

HI!

Thanks for the answer but I can't unify all into one sheet because it will be unmanageable, because we have a lot of data about each people into his sheet.

It already works fine but I want to reduce size file and calculation time. I read the opposite answer about this: some say you must use only one file even if it was big and complex, and others say that is better separate files.

I hope you with your knowledge can say me which of these two options is the best.