Fishboy
Well-known Member
- Joined
- Feb 13, 2015
- Messages
- 4,267
Hi all,
I am looking for someone with some spare time ("What's that?" I hear you ask) to have a detailed look over a personal project I have been working on. I have created an Excel 2010 workbook designed to monitor market prices of items in an online game I play, as well as keep records of my sales and purchases. The core data this all works from is obtained from a number of CSV files which I import into my workbook via various macros. The rest of the spreadsheet basically references the background data with a number of custom lookups to provide the specific information I am looking for. So far so good.
The problem I am having now is the workbook is becoming increasingly sluggish and cumbersome, and I cannot figure out if it is a specific thing that is causing it, or if it is the fact that the sales and purchase logs are exponentially expanding, or maybe a possible cumulative effect of all the macros, named ranges and lookups going on.
The bigger import macros now take multiple minutes to run instead of seconds, the screen hangs for a while and says not responding, but eventually everything comes back to life.
Due to minor changes creating tidal waves of updates across the workbook I have had to switch mainly to manual calculation on most sheets, or at least code individual sheets so wherever possible they only calculate when they are active.
What I am really looking for is a willing volunteer to have a look at my workbook and macros to see if they can spot anything glaringly obvious that I have done wrong in my haste or eagerness to add more functionality.
If any experts are interested in a bit of a challenge or are looking for a little side project to look at, please respond here and I will PM you a link to the workbook and some example CSV files used for importing.
As always, thanks for your time and I appreciate any help that may be offered.
Cheers,
Fishboy
I am looking for someone with some spare time ("What's that?" I hear you ask) to have a detailed look over a personal project I have been working on. I have created an Excel 2010 workbook designed to monitor market prices of items in an online game I play, as well as keep records of my sales and purchases. The core data this all works from is obtained from a number of CSV files which I import into my workbook via various macros. The rest of the spreadsheet basically references the background data with a number of custom lookups to provide the specific information I am looking for. So far so good.
The problem I am having now is the workbook is becoming increasingly sluggish and cumbersome, and I cannot figure out if it is a specific thing that is causing it, or if it is the fact that the sales and purchase logs are exponentially expanding, or maybe a possible cumulative effect of all the macros, named ranges and lookups going on.
The bigger import macros now take multiple minutes to run instead of seconds, the screen hangs for a while and says not responding, but eventually everything comes back to life.
Due to minor changes creating tidal waves of updates across the workbook I have had to switch mainly to manual calculation on most sheets, or at least code individual sheets so wherever possible they only calculate when they are active.
What I am really looking for is a willing volunteer to have a look at my workbook and macros to see if they can spot anything glaringly obvious that I have done wrong in my haste or eagerness to add more functionality.
If any experts are interested in a bit of a challenge or are looking for a little side project to look at, please respond here and I will PM you a link to the workbook and some example CSV files used for importing.
As always, thanks for your time and I appreciate any help that may be offered.
Cheers,
Fishboy
