shared workbook very slow

[robz228]

Hey all, i have a shared workbook used across 8-10 computers, running a lot of vba and forumlas. it ends up running terribly slow after a while and i have to unshare and reshare it for it to speed up.


Is there any good practice tips to avoid this situation in shared workbooks? some kind of setting to avoid everything getting so clogged up?

 

[Faseeh]

Hi Rob,


Please see these link, might help you:


http://chandoo.org/wp/2012/03/26/excel-speedup-optimization-tips-by-experts/

http://chandoo.org/wp/2012/03/27/75-excel-speeding-up-tips/


Regards,

 

[SirJB7]

@robz228

Hi!

Maybe sharing it less promiscuously?

Regards!