Results 1 to 8 of 8

Macro to run formulas more efficiently

Threaded View

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    Phila
    MS-Off Ver
    Excel for Mac 2011
    Posts
    25

    Macro to run formulas more efficiently

    Dear Gurus,

    I generally analyze data by applying formulas. However when the data I need to analyze is too big (500 columns and 60000 rows), calculating all the formulas takes excel several hours, if not days. This slows the performance of my computer dramatically and I would like to know if it is possible to have a macro run the formulas on a step wise manner and in a much more time efficient way. In the attached file you can see an example of the data and how the formulas are applied in a step wise manner. Let me know if you would like me to clarify further.

    Many thanks in advance for your help,
    Ale
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can this be done more efficiently in Acess?
    By PropertyGuy in forum Access Tables & Databases
    Replies: 1
    Last Post: 08-12-2014, 04:44 PM
  2. [SOLVED] Macro to more efficiently copy/paste every 21 rows
    By Phil_Packer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-23-2013, 03:08 AM
  3. [SOLVED] Can this macro be written more efficiently?
    By alpinesd in forum Excel General
    Replies: 4
    Last Post: 06-16-2012, 02:46 AM
  4. Excel 2007 : Sum values efficiently
    By dzaboo in forum Excel General
    Replies: 0
    Last Post: 09-23-2010, 01:16 PM
  5. Help to get Macro operating efficiently
    By mr_teacher in forum Excel General
    Replies: 4
    Last Post: 09-01-2006, 04:13 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1