+ Reply to Thread
Results 1 to 2 of 2

Help! Calculating Threads Constantly - tried the usual suggestions

  1. #1
    Registered User
    Join Date
    12-09-2020
    Location
    United Kingdom
    MS-Off Ver
    Office 365
    Posts
    1

    Exclamation Help! Calculating Threads Constantly - tried the usual suggestions

    Dear reader,

    I am currently having issues with a large file I use on a monthly basis. This file is around 12,000KB in size and has quite a few formula.

    The issue: every time I make any changes to any cell, my excel starts calculating threads. Any formula in the sheet are then updated.

    If I am working in another workbook at the same time that this large file is open, it will pause anytime I am changing anything and start calculating threads.

    I have autosave turned off (files are saved in OneDrive) and calculations turned to manual. I have removed worksheets from the file to make it smaller but this has not helped (used to be 16,000 KB).

    I do not have this issue with any other file. Only this one. It makes tasks significantly longer to complete.

    Any suggestions would be most welcome as I have only seen advice to turn autosave off and calculations to manual which I have already been doing.

    Many thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,961

    Re: Help! Calculating Threads Constantly - tried the usual suggestions

    See this thread.

    https://www.excelforum.com/excel-gen...ry-action.html

    The Trouble Shooting link and my later response might point you in the right direction.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating 8 Threads (Inefficient Code)
    By Fugdkn in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-30-2020, 03:37 PM
  2. Calculating 4 threads and colorindex - help with formula
    By nonabc86 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-13-2020, 11:39 AM
  3. [SOLVED] 4 threads calculating. Massive slowdown since adding sumifs formulas
    By Johnny247 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-28-2019, 12:32 PM
  4. Replies: 4
    Last Post: 07-20-2019, 06:05 PM
  5. Calculating (4 Threads)
    By AndreaJean18 in forum Excel General
    Replies: 1
    Last Post: 05-22-2019, 10:01 PM
  6. Replies: 0
    Last Post: 11-21-2014, 09:25 AM
  7. xls spreadsheet constantly calculating causing navigation issues
    By Matabi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2006, 08:10 AM

Tags for this Thread

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