Results 1 to 4 of 4

Worksheet calculations very slow...how to improve and/or make efficient

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-11-2008
    Location
    uk
    MS-Off Ver
    2010; 2016
    Posts
    400

    Worksheet calculations very slow...how to improve and/or make efficient

    Hi All,

    I've been working on a little project regarding Tax payments etc.

    It consists of 3 worksheets, which are fundamentally:
    1) putting the values in,
    2) a VAT / Tax calculator and,
    3) a year on year summary sheet.

    I am happy with the way the projects inputs values etc but if I include the summary sheet, the dreaded " calculating 2 processors" warning rears its ugly head and the time taken to do anything is a lot lot longer.

    If I remove the year on year summary, then everything works OK, and so could someone please have a look at this and see where I can make improvements / use alternative methods to get the same results.

    I attach the file in two forms....one with no summary and one with.

    Hope you can help as this project is very very close to finishing!!

    Regards,

    Skyping
    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. Improve Calculations Speed
    By samcdavies in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2015, 09:14 PM
  2. How to improve performance of my code?, now is too slow!!
    By Laurelb in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-25-2015, 03:15 PM
  3. Very Slow Macro - Can this be more efficient?
    By TonyGill in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-04-2013, 03:03 PM
  4. Slow update (how to improve)
    By Stingone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2012, 01:47 PM
  5. Replies: 10
    Last Post: 09-24-2012, 05:05 AM
  6. Help with more efficient formatting and calculations
    By Cook1970 in forum Excel General
    Replies: 2
    Last Post: 06-21-2011, 01:40 PM
  7. Improve slow code - programming a sub which displays a polynomal function
    By reteid2222 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2008, 08:59 AM

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