663 reputation
415
bio website
location
age
visits member for 3 years, 9 months
seen Jun 26 at 13:55

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.
Mar
31
comment If you block an .exe file in Windows Firewall, are you also blocking the .dll files it uses or it needs to be done separatly?
One question, when you say "when you block an executable, you prevent it from importing any .DLL's that it would normally import", are you talking about Windows Firewall? I don't understand how blocking internet connections would cause a .DLL not to be imported. Shouldn't that render most programs unable to work? I'm talking about the equivalent to the "Allow X program to communicate on these networks" dialog: static.arstechnica.com/7000_7100_windows_firewall2.png
Mar
31
comment Replace a laptop hard drive (Ubuntu and Windows 7 installed)
Yes, but just a couple of times. Didn't have any problems. I used the disk to disk beginner mode.
Mar
29
revised How to avoid keyboard layout automatically changing on windows
added windows xp tag because this issue's solution is most likely to be specific to that version