663 reputation
416
bio website
location
age
visits member for 3 years, 10 months
seen Aug 4 at 18:11

Aug
4
answered Keyboard shortcuts in non-English version of Microsoft Office
Aug
4
awarded  Citizen Patrol
Aug
4
comment Bring back the object browser in Word 2013
I've downgraded to Office 2010, so I can't test to see how your proposal works out. It does sound as if it should work. I'm sorry.
Jul
2
awarded  Curious
Apr
21
awarded  Caucus
Apr
9
awarded  Yearling
Apr
9
revised How can I find out which parts of an Excel workbook are the biggest in size?
fixed numbering
Apr
9
awarded  Self-Learner
Apr
9
comment How can I find out which parts of an Excel workbook are the biggest in size?
That's because Excel stores both the values and the formulas (vs just the values in the original). // I found out the instructions below had an error; with the corrected instructions I managed to find and fix the error.
Apr
9
comment How can I find out which parts of an Excel workbook are the biggest in size?
Thanks, but notice the method was lacking an important step and lead to an error. Now it works correctly and I got to id the worksheet!
Apr
9
revised How can I find out which parts of an Excel workbook are the biggest in size?
fixed an error in the explanation
Apr
9
revised How can I find out which parts of an Excel workbook are the biggest in size?
added 19 characters in body
Apr
9
comment How can I find out which parts of an Excel workbook are the biggest in size?
It has no objects neither. I don't get this at all!
Apr
9
comment How can I find out which parts of an Excel workbook are the biggest in size?
With the solution below, I found a 390MB uncompressed worksheet with only 130 rows, 8 columns, no format besides freezed panes, and having ONLY VLOOKUPs to other sheets of the workbook. I don't get how it got to be so, so heavy.
Apr
9
comment How can I find out which parts of an Excel workbook are the biggest in size?
Thanks for answering. It is very a very uncommon problem. The main problem involves neither images nor the last row bug (although thanks for pointing it out, a couple of the MB were actually due to that issue in another problematic sheet and I didn't know that it could increase file sizes, I just thought that it messed with the scrollbar).
Apr
9
answered How can I find out which parts of an Excel workbook are the biggest in size?
Apr
9
asked How can I find out which parts of an Excel workbook are the biggest in size?
Apr
3
accepted Can an administrator of a Windows domain see a user's password?
Apr
3
asked Can an administrator of a Windows domain see a user's password?
Apr
3
comment How do I find which Pivot Tables has an error in Excel 2010?
Did the error message specify a sheet number? Have you tried saving as xlsb and then back to the original format? Sometimes that fixed some corruption issues for me.