Slow Calculation

Hello,

I have a spreadsheet and when i run it on excel 2007 it runs perfectly but when i run it in 2003/2007 after each entry in a cell or a check box is clicked the sheet calculates and it takes a while to complete unless I click any random cell which then calculates instantly.

I can't figure this out, any suggestions?

Hi Richard,

Thanks for your quick reply! It was created on 2003 and it is .xls file. I open it in 2010/07 and works perfect and when i amended it i always made sure to save it as .xls without and 2007/2010 add ons

hi Richard,

i can't upload it as it got sensitive data on it . the spreadsheet is about 9mb and it has about 12 sheets, macro etc.. i done all the usual bit to streamline it reset last cell .. clear variables at the end of the macro etc.. etc..

what puzzles me it behaves weird on 1 pc, i tried it on 3 different pc with different set-ups. i am blaming the pc or excel itself on the machine.

what it is doing on this particular pc is as soon i enter a value ina cell or tick a check box, in the status bar i can see the calculation percentage going up slowly then if i select another cell with out entering any values the calculation goes to 100% instantly

What hardware has that PC, I mean, how much ram does it have; you aren't using a small file. Does the harddisk need cleaning and defrag ?

its a dual core with 2 gig ram. hard disk is kept very clean using ccleaner & defragler twice a week .. the odd thing is when i input a value/text in a blank cell and press enter it calculates slowly and if I press enter twice it calculates instantly ..

Hello,

FYI - I though i post this as it might help other, i found what the problem is with excel 2003, it is explained on the below link.
http://support.microsoft.com/default...;en-us;Q243495
and sadly there is no practical solution. the only thing I can think of is to delete all formulas and do a macro on the change event to insert the formula in the relevant cells upon user input. i.e. if the user starts from row "1" cell "a" then formulas will be filled in the next cell and if the the first cell of the row is blank then there be no formula generated..

hi
A lot by the looks of it, joking a side. I have a lot of different formulas as the spreadsheet does a lot of different things. I done this for work though if i had a say i would have used access and not excel but we do not have access at work. The spreadsheet is more of a data base than anything else, each record(row) has 5 dates which they are validated (if the date is before today the cell changes colour) and 3 of the date have 2 check boxes next to them, depending on which one is ticked it is copied on another sheet, there are 5 different types of variations in all, 5 different sheets. They all use vlookup and if(and/or formulas though the formulas are not long the biggest one has 3 precedents. From each Variation sheet i have a userform with different options like exporting the relevant data to csv and emailed to a specific email, mail merge which produce one print job and then saves each letter with the person name & date in a specific folder, on one of the variation sheets and on the main i have formulas that look on another sheet for addresses which are downloaded from the net as a web query and i have another option to generate a check sheet (importing data printing etc..) also looking into the other sheets for data. Then i have another sheet with 4 different calculators using workday to calculate the 3 dates depending on time they work and if they had an interruption in service etc .. it also looks into another sheet where i have dates stored which are holidays etc..

each sheet has 500 rows and when i finished it was 22mb though after i streamlined it i reduced it to 9mb ..