jaynorman46
New Member
- Joined
- Apr 5, 2011
- Messages
- 23
Hi,
I have a rather complicated question. I have about 15 reports(Excel) on a share point that get run every month. All of these reports have extremely complicated macros, PI data links and calculations. I have one workbook(Excel) that opens all of them up, one by one and recalculates them and saves each workbook in its appropriate folder (Entire process is automated. Naturally this entire process takes AGES to complete and ties up my CPU for at least three days. I was wondering if there is anyway I could get this process to run in share point land... or in other words not tie up my computer for three days.
If you need further information let me know.
I have a rather complicated question. I have about 15 reports(Excel) on a share point that get run every month. All of these reports have extremely complicated macros, PI data links and calculations. I have one workbook(Excel) that opens all of them up, one by one and recalculates them and saves each workbook in its appropriate folder (Entire process is automated. Naturally this entire process takes AGES to complete and ties up my CPU for at least three days. I was wondering if there is anyway I could get this process to run in share point land... or in other words not tie up my computer for three days.
If you need further information let me know.