+ Reply to Thread
Results 1 to 2 of 2

Excel file open too slow

  1. #1
    Registered User
    Join Date
    11-20-2016
    Location
    sweden
    MS-Off Ver
    2013
    Posts
    12

    Excel file open too slow

    Hi,

    I created an Excel file its size is 0,5MB which contains around 80 sheets, when starting this it takes too long time to open, no matter if open it directly or start excel and then open it.
    I have another file which is almost 5MB containing more than 600 sheets and macros , this one starts almost direcly when clicking on it. and its so with my other excel files all start very quick, but i have the problem only with this file. Tried it on another pc its starts slow also.

    I am running win 7 on my pc & office 2013 , my pc a laptop spec. are, i5 3rd generation cpu, ssd HDD, 16 GB ram. I unistalled office 2013 & installed today 2010 the problem presists.

    I searched the internet and tried but nothing helped.

    I dont know if i am posting in right place, any help appreciated

    Best Regards

    Younan

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,289

    Re: Excel file open too slow

    Check for:
    Array formulas
    Volatile formulas (eg indirect)
    Conditional format formulas
    Formulas that search through whole rows or columns

    These thing makes excel slow
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ 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. [SOLVED] Slow to open excel file
    By d7882 in forum Excel General
    Replies: 8
    Last Post: 11-06-2017, 04:40 PM
  2. Excel file VERY slow to open up
    By clogistics in forum Excel General
    Replies: 3
    Last Post: 01-08-2016, 08:08 AM
  3. Open xls file is unreasonable slow.
    By mrkhchan in forum Excel General
    Replies: 2
    Last Post: 01-09-2015, 12:51 PM
  4. Excel File very slow (3-4 minutes) to open
    By jmmach72 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2013, 02:02 PM
  5. Indexing Making File Very Slow to Open
    By cpiname in forum Excel General
    Replies: 4
    Last Post: 09-01-2010, 10:44 AM
  6. Excel Slow File Open Directory Response
    By Dave P in forum Excel General
    Replies: 0
    Last Post: 09-29-2005, 09:05 PM
  7. [SOLVED] Open file Slow on Excel 2003
    By Vuka in forum Excel General
    Replies: 0
    Last Post: 03-17-2005, 02:06 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