Find & Replace vs Cut & Paste

G

Guest

Guest
I have a massive collection of formulas (250 cols x 900 rows) which must be calculated on a series of quarterly data. The quarterly data is 20 columns and usually about 50000 rows.

I've tried several methods looking for a fast way to do this. The recalculation time is enormous. I don't know if it's just because of the number of formulas and that most of them are various dcount and daverages. On a 433 mhz pentium 3, this is taking about 2 hours to calc.

I've tried pasting in formulas where they all refer to a database name which is the same in each spreadsheet. I've also tried pasting the formulas in with direct cell references (however, this requires turning them into text and then using find and replace to turn them back into formulas. Anything else seems to mess up some of the references).

I haven't yet tried pasting the data into a spreadsheet which already contains the formulas and hitting calc.

I have also run into out of memory error on some spreadsheets despite about 200 meg of free ram and about 1.5 gig of free disk space.

Suggestions? Is something with Excel's undo slowing this down? Is it something with the clipboard?
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top