[FONT="]Hi All,
I have an excel 2007 based tool. The workflow involves two phases.
In first phase; tool pull data from sharepoint site(Data is present in excel files at sharepoint) and copy it to another sheet on local drive.However this copy is not a simple as-it-is process. It involves searching/lookups and other mathematical processing in sharepoint data through running formulae.
In second phase the data published in the sheet is used further.
Now, I am facing a performance issue in first phase where tool has to pull data from sharepoint.
I am planning a design change in order to improve performance.So if anyone has any sort of experience in similar case, please suggest.
P.S. I am thinking of pulling data from sharepoint as it is in some in memeory data structure which will be further used for populating the sheet.This I am planning to do with the help of macro.
Thanks in advance[/FONT][FONT="] [/FONT]
I have an excel 2007 based tool. The workflow involves two phases.
In first phase; tool pull data from sharepoint site(Data is present in excel files at sharepoint) and copy it to another sheet on local drive.However this copy is not a simple as-it-is process. It involves searching/lookups and other mathematical processing in sharepoint data through running formulae.
In second phase the data published in the sheet is used further.
Now, I am facing a performance issue in first phase where tool has to pull data from sharepoint.
I am planning a design change in order to improve performance.So if anyone has any sort of experience in similar case, please suggest.
P.S. I am thinking of pulling data from sharepoint as it is in some in memeory data structure which will be further used for populating the sheet.This I am planning to do with the help of macro.
Thanks in advance[/FONT][FONT="] [/FONT]