Large, Slow Excel Workbook

dave3009

Well-known Member

Joined

Jun 23, 2006

Messages

7,146

Office Version

1. 365
2. 2021

Platform

1. Windows
2. Mobile
3. Web

• Aug 31, 2008

• #2

Hit it with this addin and see if it reduces it any

http://support.microsoft.com/kb/244435

 

Upvote 0

E

excel_lover

New Member

Joined

Aug 31, 2008

Messages

22

• Aug 31, 2008

• #3

Hey looks v useful.. anyone had any experience of it? - Does it work well? - Is there any risk at all?

 

Upvote 0

dave3009

Well-known Member

Joined

Jun 23, 2006

Messages

7,146

Office Version

1. 365
2. 2021

Platform

1. Windows
2. Mobile
3. Web

• Aug 31, 2008

• #4

No risk, it just resets the last used cell which can 'bloat' files. I have reduced a file sent to me via email from 8Mb to 3-4Mb without changing the file at all, just running this addin.

Mind and save your files after use to retain it's newly reduced filesize if applicable

 

Upvote 0

Smitty

Legend

Joined

May 15, 2003

Messages

29,536

• Aug 31, 2008

• #5

Welcome to the Board!

Just a note that if your wb is that big you might want to consider moving to a database, like Access.

 

Upvote 0

J

Jerryjaysr

New Member

Joined

Jun 23, 2006

Messages

7

• Aug 31, 2008

• #6

How do you run this addin?
I have it downloaded and selected in Tools

 

Upvote 0

dave3009

Well-known Member

Joined

Jun 23, 2006

Messages

7,146

Office Version

1. 365
2. 2021

Platform

1. Windows
2. Mobile
3. Web

• Aug 31, 2008

• #7

It's under the file menu should be a new item there called Clear Excess Formating in .................................., on XL07 it'll be in your Addins tab

p.s. If it has a significant impact on your file please post back

 

Upvote 0

xenou

MrExcel MVP

Joined

Mar 2, 2007

Messages

16,836

Office Version

1. 2019

Platform

1. Windows

• Aug 31, 2008

• #8

If you have lots of lookups this can slow down your workbook - I'm sure there's other types of formulas that will also effect performance. External links for sure. That's a very large workbook. What do you have in there?

 

Upvote 0

J

Jerryjaysr

New Member

Joined

Jun 23, 2006

Messages

7

• Aug 31, 2008

• #9

Never mind..I found it and it screwed my workbook up terribly.

 

Upvote 0

dave3009

Well-known Member

Joined

Jun 23, 2006

Messages

7,146

Office Version

1. 365
2. 2021

Platform

1. Windows
2. Mobile
3. Web

• Aug 31, 2008

• #10

How? All the code does is reset the last used cell on each sheet in a workbook so I can't think what it might have done.

 

Upvote 0