Share via

64-Bit File running slow!!

Anonymous
2017-07-20T17:44:03+00:00

I've been running a very large Excel file written originally on a 32 Bit platform.  Improvements made along for the past few years.

Just got a new machine, Windows 10, Office 2013 - 64 Bit, 8 RAM, i5 Pro processor.

When I ran the 32 Bit file and view the task manager, I noticed it never went above 1.4/1.5 GB.  This was doing a large paste manipulation.

After research, I found that even though I had 64 Bit platform, if the file was originally written in 32 Bit, I was limited in memory to 32 Bit.

So, off I go over the past several days, re-writing from a fresh 64 Bit file, copying/pasting, re-establishing formulas, print areas, etc.

On some of the same large pastes, I did notice the RAM now climbing well above 3 and 4 GB so thought it was finally running better.  However, I am doing some final pasting/manipulating, and notice the RAM is now only utilizing 1.2/1.3/1.4 GB.  Just stops and spins.  It does eventually do the task being asked.....just take a long time.

Is there anything else I can do?  Did copying tabs in 32 Bit file to the 64 Bit file carry over some restriction??  This is all I can think of.

File size with about 6 Macros is around 29MB.

Thanks for any help!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-07-26T01:38:59+00:00

    Thank you for getting back to us. If you are unable to perform a safe boot, let us repair your Office application and check if it helps. Please follow the steps below:

    1. Right-click the Start button (lower-left corner), and select Programs and Features on the pop-up menu.
    2. Right-click the Microsoft Office product you want to repair, and select Change.
    3. From the "How would you like to repair your Office Programs" screen, select Online Repair to make sure everything gets fixed, and then select Repair. The Quick Repair option is also available, which runs faster but only detects and then replaces corrupted files.
    4. Follow the instructions on the screen to complete.

    Let us know if this will help resolve the issue.

    Thank you.

    0 comments
  2. Anonymous
    2017-07-24T13:29:12+00:00

    Just got a new machine, Windows 10, Office 2013 - 64 Bit, 8 RAM, i5 Pro processor.

    That's not enough, plug 16GB in addition and you'll see a difference on 64-bit applications.

    On the other hand: The subject is "running slow", but all you talk about is how many memory is used... There is no direct connection between these things. Even if that is published in general.

    Andreas.

    Thanks Andreas....maybe I'm more hung up on RAM than I should be.  May be the processor speed as a key to quicker performance.

    0 comments
  3. Anonymous
    2017-07-24T13:27:30+00:00

    Thanks Anna for the response.  Unfortunately, it's a company computer and I have no ability to be the "admin" for the machine...so can't do a safe boot.

    But I did a little further testing, and it does look like you are correct.

    I copied and pasted a large selection in both files, and got almost identical figures.

    32-Bit file (xlsb), length of copy 2 min, 51 sec (RAM used 3.76 GB)

    64-Bit file (xlsm), length of copy 2 min, 31 sec (RAM used 3.53 GB)

    64-Bit file (xlsb), length of copy 2 min, 34 sec (RAM used 3.54 GB)

    So based on this, it does look my RAM is being utilized correctly. 

    Therefore (Andreas), it must come down to processor speed.  Mine is i5-5300U @ 2.30GHz 2.29 GHz.  I will say the files do run more stable on my machine compared to others.  On other co-workers, we've seen rare occasions where the machine just stops and says out of memory.  However, they are on 32 Bit machines and Windows 7.

    Any major differences running the file as an (xlsb), instead of (xlsm)?  The file size is MUCH more manageable as an (xlsb).  Appreciate the help!

    0 comments
  4. Andreas Killer 144K Reputation points Volunteer Moderator
    2017-07-22T08:13:45+00:00

    Just got a new machine, Windows 10, Office 2013 - 64 Bit, 8 RAM, i5 Pro processor.

    That's not enough, plug 16GB in addition and you'll see a difference on 64-bit applications.

    On the other hand: The subject is "running slow", but all you talk about is how many memory is used... There is no direct connection between these things. Even if that is published in general.

    Andreas.

    0 comments
  5. Anonymous
    2017-07-22T01:11:23+00:00

    Hello,

    Since you now have a 64 Bit platform, there shouldn't be an issue in opening an Excel file written originally on a 32 Bit platform. For us to validate what is causing the issue, let us perform some troubleshooting steps. Please follow the steps below:

    1. Close all the active Excel file. Once done, perform a clean boot. It will start Windows by using a minimal set of drivers and start up programs. It will also eliminate software conflicts that could occur when you install a program, or an update, or when you run a program in Windows.
    2. Use the /safe option to open an Excel application. Here's how:

              a. Right-click the Start button (lower-left corner) in Windows, and click Run.

              b. In the Run box, type excel /safe, and click OK.

    Let us know if there's any difference after performing the suggested steps.

    Thank you.

    0 comments