+ Reply to Thread
Results 1 to 3 of 3

failure to open Excel 2016 worksheet

  1. #1
    Registered User
    Join Date
    05-16-2011
    Location
    NC
    MS-Off Ver
    Excel 2016
    Posts
    28

    failure to open Excel 2016 worksheet

    Hi all - I'm running Excel 2016 on a Surface. Excel appears to work OK for small worksheets. I've got two worksheets which are 32,405 KB and 34,839 KB that take about 4 hours to open. I opened one file at 12 noon EDT and watched Task Manager Microsoft Excel CPU settle down to 28.6% and my Memory increment fairly quickly to 377.4 MB where it stopped dead. After about an hour it started incrementing and got up to 501.6 MB. At 3:17 pm today it was 495.6 MB. CPU remained around 28.6 to 29.2%. Right now, CPU is 21.4% and Memory is 100.3 MB. Can anyone tell me what's going on.

    When I ran these same big files on Excel 2013 on my Dell Latitude E5540 I never had a bit of trouble.

    Thanks a million.

    Jonathan Smith
    Greensboro NC
    USA

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: failure to open Excel 2016 worksheet

    This works sometimes

    Load them on your Dell
    Copy each sheet to a new workbook.
    Save the workbook
    Open the new workbook on your Surface
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    05-16-2011
    Location
    NC
    MS-Off Ver
    Excel 2016
    Posts
    28

    Re: failure to open Excel 2016 worksheet

    Thank you for thinking about this and for your suggestion.

    Jonathan Smith

+ 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. Excel 2016 Hyperlinks Won't Open
    By drew.lewis.rtr in forum Excel General
    Replies: 4
    Last Post: 08-17-2017, 12:25 AM
  2. Workbooks collection only returns one open workbook in Excel 2016
    By myfathersson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2017, 03:32 PM
  3. [SOLVED] Excel 2016 'Arrange All' with two open spreadsheets
    By maacmaac in forum Excel General
    Replies: 3
    Last Post: 04-12-2017, 08:32 AM
  4. VBA Open FilePath from FTP location - Excel 2016 error
    By mwc360 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2017, 01:34 PM
  5. Open 2 workbooks in Excel 2016 cannot click controls or enter cells
    By Jason_Chan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-27-2017, 12:03 PM
  6. Excel 2016 Mac - Open File Macro
    By DylanM in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-10-2016, 08:53 AM
  7. Replies: 1
    Last Post: 08-24-2016, 03:55 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