Excel fill down formula recalculation question
I open around 150 spreadsheets and run a macro that fills down the data
on the row that the cursor is on down to the next row and then moves the cursor down to the appropriate location. There are some formulas that get recalculated just because of the nature of the fill down to the next line. On my old Compaq Celeron 433 with 96 mb of memory running Excel 2000 it only took 26 seconds to cycle through all of the spreadsheets and do the fill down and recalculations. Now with my new Dell Celeron 2700 with 1024 mb of memory running Excel 2003, it takes 35 seconds to run. I don't understand why it takes longer on a faster machine with more memory. I went through and checked all of the possible performance explanations on the MVP dmvritchie web cite and another besides and no explanation seemed to explain why my visual basic function should run slower on a faster machine with more memory. Anyway I set calculation to manual while I cycled through the spreadsheets doing the fill down and then at the end turned calculation back onto automatic and the macro only took 18 seconds to finish which is more in line with what I was expecting to see in the first place. So I don't understand how to explain this discrepancy unless there is some kind of conflict between the first fill down and recalculation and then having visual basic move to the next spreadsheet and start doing the next fill down operation again and possibly the next calculation on that spreadsheet as opposed to doing all of the fill downs and then doing the formuala recalculation at the end. If I remember right didn't Microsoft change some things in Excel 2003 so that calculated numbers would be more accurate to a smaller decimal place? Thanks Dick |
Excel fill down formula recalculation question
FWIW I have discovered that Copy/Paste methods work faster than cycling
cells - especially if formats are required. --- Message posted from http://www.ExcelForum.com/ |
Excel fill down formula recalculation question
It would seem counter intuitive to expect that copying to the clipboard
and then pasteing onto the next line would be faster so I never even thought to try that. Thanks for the suggestion. I will give it a try. DickN BrianB wrote: FWIW I have discovered that Copy/Paste methods work faster than cycling cells - especially if formats are required. --- Message posted from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 03:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com