Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Find & Replace vs Cut & Paste

  1. #1
    Guest

    Default

    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?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Take a look at...

    http://support.microsoft.com/default...b;EN-US;q72622

    Also, consider moving some of your infrequently updated data to a separate workbook that you keep closed and use absolute references to that document.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •