chilly_bang
Board Regular
- Joined
- Jun 17, 2016
- Messages
- 57
Hi
i have tables with formulas referencing other tables, which are placed on the firm's remote server, where i login through VPN. Opening and saving of such files (referencing remote files) takes too much time and CPU power - until 95% of CPU power. And, i can't work with values instead formulas - i need formulas because remote files are changing and i need their up-to-date state.
What are common ways to optimize such setup? Are there maybe any VBA scripts, which copy remote data on demand?
i have tables with formulas referencing other tables, which are placed on the firm's remote server, where i login through VPN. Opening and saving of such files (referencing remote files) takes too much time and CPU power - until 95% of CPU power. And, i can't work with values instead formulas - i need formulas because remote files are changing and i need their up-to-date state.
What are common ways to optimize such setup? Are there maybe any VBA scripts, which copy remote data on demand?
Last edited:
