Excel expert needed

Also remove ANY formatting on the sheets, make sure the cells have no fill and no border. This helped me once when I had a similar issue.
 
Update: 3rd party has admitted that the sheet is badly designed. Simple as that...
 
LaraC said:
Were they able to pinpoint what caused it to malfunction?
Click to expand...

Nope just came down to the total complexity. Gradually reducing the size of the workbook increased performance. They are going to do a redesign of the report to split info into more workbooks rather then 1 with multiple sheets.
 
Splitting it into more workbooks is going to complicate things for the end-user.
It is preferable to keep all the data on one sheet and use Pivot tables and charts to display it in an easy to read format. Then again, I have no idea how much data is involved or how the financial software program handles its data.
 
Ipwn 4 said:
Nope just came down to the total complexity. Gradually reducing the size of the workbook increased performance. They are going to do a redesign of the report to split info into more workbooks rather then 1 with multiple sheets.
Click to expand...

In my view, they should not be using excel for this. Excel's power and correct usage is for what if analysis. Although excels capability to handle large amounts of data has improved over the years, this is still the incorrect application.

What the developers should do is export all the data to a database and then have queries/views on the data for reporting (make the front end web/cloud enabled to minimise client support). Excel can then be used for adhoc reporting by quering the database. When used with PowerPivots it is really powerfull.

I suspect that this is a case of a legacy application and process not keeping up with current technology.
 
I make use of excel's VBA for reporting purposes, sometimes i can do stuff in excel which i cant to in Crystal Reports.
I normally use a SQL query in VBA to only get the data I'm interested in.

That way I'm able to reduce the data by allot, Ive never really had stability issues.
If they really cant reduce the data, then they should rather look at a different type of tool for the task
 
Ipwn 4 said:
Hi Guys,

I am look for an excel expert to assist with an issue we currently have:
a client of ours is using spreadsheets that are generated from dumps from their accounting system. These workbooks are all over 7MB in size and cause frequent crashes of Excel.

Most of what I can find suggests that the sheets are badly created but I honestly don't know enough about accounting to make sense of half of what they are trying to accomplish. We have tested on multiple systems which multiple OSs and versions of Excel, the only common denominator is the workbook itself.

I need someone who has experience dealing with sheets of this size and running Excel efficiently to take a look and either confirm our findings or find the actual problem. You will be paid for your time spent.

Drop me a PM if you know of someone, thanks in advance!
Click to expand...

7MB isn't big by any means.

Some of our reports that gets dumped to Excel before processing is in excess of 50MB.
 
Only thing I can say is that excel can seem quite inconsistent with large data.Some random format can make a small 100kb document become like 15mb .So maybe check the source file as step number one .I you have all the data in organised format run pivots off it or what u trying to achieve with the data?
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X