3 Reasons Why Your Excel File Is So Big - LIVE
Excel files seem to have a mind of their own; one minute they are a perfectly manageable size, and the next they are 10gb or more. Such a large Excel file takes time to open, to save and to attach to email - it is generally difficult to work with.
In this livestream, Chris talks about three ways to limit Excel file size (without deleting data), in order to make your life easier. If your file has suddenly increased in size, it is likely that one of the things is to blame:
05:23 Excessive Formatting
11:47 Inefficient Formulae
20:30 Hidden Objects
1) Excessive formatting 05:23
Excel allows us to quickly select a whole row or column by clicking on the row number or column header. That does not mean, however, that we should format whole rows or columns! To do so can create excessive file size, and it is formatting that we don't really need.
Rather, take the time to plan how much formatting you will need - how much data is likely to be inputted to the file, for example? Prevention is better than cure and planning really helps. Take the time to format only the range you need.
If you need to clean up a file with excessive formatting, keyboard shortcuts can help you select to the end of the columns or the rows. Check out our keyboard shortcuts video for Windows here:
• 19 Excel Beginner Shortcuts for 2019 ...
2) Inefficient Formulae 11:47
What creates an inefficient formulae? A common source of problems is the range to which the formulae 'points'; in other words, the reference you put into the formula. If this is too big, it detracts from the efficiency of the workbook, and can add additional size to the file.
It is tempted to simply select a whole column or row (eg. D:D) since it is easily done, and means we do not have to think about the likely size of the dataset. But to do so can make your life more difficult in the long run. Again, try to reference only the range that you need - planning is key!
If you think your workbook contains inefficient formulae, back up the file and try deleting the problematic formulae altogether. Does file efficiency improve? If so, try to rebuild the formulae with proper range references.
3) Hidden Objects 20:30
Yes, things we cannot immediately see could be the source of the problem. It is important to check for hidden sheets as these may be problematic: to do so, right click on the sheet tab and choose a sheet to unhide. In the video, Chris talks about the mysterious 'xlveryhidden' visibility setting and how to deal with this VBA can help you quickly loop through all sheets and make them visible.
Watch our video about understanding complicated Excel files for more:
• Understand Complex Excel Spreadsheets...
After the short presentation, Chris answers viewer questions about Excel. Topics include how to trigger macros in Excel VBA, and how to communicate with your client in Excel consultancy projects - we hope you get some value from the discussion.
Why not join Chris on the next livestream to get answers to your Excel questions? Tuesdays @ 1800 UK time.
------------------------------------------------------------------------------------
🎁YOUR EXCEL CHEATSHEET
🎁1 Page Summary Of What You Need To Know
https://tinyurl.com/yc7jlmbs
Get in touch with Tiger using the platforms below:
/ tigerspreadsheetsolutions
/ tigspreadsheets
http://tigerspreadsheetsolutions.co.uk
Also on Insta :-)
Watch video 3 Reasons Why Your Excel File Is So Big - LIVE online without registration, duration hours minute second in high quality. This video was added by user Tiger Spreadsheet Solutions 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,307 once and liked it 28 people.