INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

MS EXcel 2013 crashing due to very high memery comsumption

MS EXcel 2013 crashing due to very high memery comsumption

MS EXcel 2013 crashing due to very high memery comsumption

(OP)
2103 Excel 32 Bit Win7 4 BG RAM

Somewhat complex 2013 Excel file is drawing on all RAM in order to function....and once loaded the computer is slowed down to an extreme level.

Cannot delete rows to reduce the file size as Excel crashes during this process.

The file was created in MS Excel 2010 6 months ago.

Any ideas on a cure or where one might to look for methods to adjust the file to remedy this issue ?

RE: MS EXcel 2013 crashing due to very high memery comsumption

Hi,

Please explain further...

"Somewhat complex" what do you consider somewhat complex?

"to function" what function? Native features? VBA code? External links?

"Cannot delete rows to reduce the file size" How many columns and rows?

"The file was created in MS Excel 2010 6 months ago." Has it functioned since that date? Any recent changes? Do you have access to a recent version of this workbook?

You might consider a repair/reload.

Control Panel > Uninstall a Program -- has repair options.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: MS EXcel 2013 crashing due to very high memery comsumption

(OP)
About 950K is the size and 24 Rows... there are graphic images within the file. One only tab is in use.

There are external links in a few cells but I do not think they are active... unless you click on them to go to the file location they represent.

No VBA that I an aware of.... is there a way I can check to confirm ? I have run in Safe Mode but no improvement.


Just saw this from MS > https://support.microsoft.com/en-ca/help/3066990/m...

However, I cannot consider upgrading to a new OS / 64B or hardware change at this time.

Was hoping to find a way to alter the file to address this issue.... one only file gives me this problem.




RE: MS EXcel 2013 crashing due to very high memery comsumption

Have you tried running it on a 64bit OS with, say, 16G or RAM or more?

Dik

RE: MS EXcel 2013 crashing due to very high memery comsumption

Osprey,
With only 24 rows, what's "complex" about this file?
Is there any VBA involved, is this all in-cell work, and are there any conditional formats?

Best Regards,
Scott
MIET, MASHRAE, CDCP, CDCS, CDCE, CTDC, CTIA, ATS

"Everything should be made as simple as possible, and no simpler."hammer

RE: MS EXcel 2013 crashing due to very high memery comsumption

Any other links? Check graphics for web links if they were copied and pasted from internet. Check links/connections to external data sources ("DATA" ribbon), they may be an input for workbook data. If you can open it in excel 2016, check if any get& transform query exists (however, you should see them in connections).
Are there any hidden/veryhidden sheets?

Quote:

There are external links in a few cells but I do not think they are active... unless you click on them to go to the file location they represent.
Do they point to existing workbooks? Make a copy of your file and remove links by hard data. Any change?

combo

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close