Excel Preview Warning
April 30, 2019
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
Do you remember early versions of Excel, when you could preview pictures in Excel's Open window? That feature is broken now - you can't preview Office files from inside their own program (see the Microsoft Support article).
However, if you try the steps below, you'll be able to see preview pictures in Windows Explorer - but read my warning below:
Then, to see preview pictures in Windows Explorer, click the View tab, and click the Preview Pane, if it's not already showing.
WARNING: When you preview files, a hidden Excel instance opens, so you might see a "File in Use" message occasionally. There's more info on my website.
Excel gives new pivot tables a numbered name, like PivotTable1. To make it easier to manage large workbooks, change those names to something descriptive - RegionSalesPT
There are only a few rules for pivot table names:
To change a pivot table name, type in the small box on the Ribbon's Analyze tab. Or, right-click on a pivot table, and click PivotTable Options. In there, you can see more of the name while you change it.
See other ways to paste pivot table values and formatting on my site.
Here are a couple of Excel articles that you might find useful or interesting.
Power Query - Jeff Lenning, from Excel University, is hosting free webinars this week - How to Stop Wasting Time with Excel. See how to automate your Excel reports, using tables, efficient formulas, and then Power Query and the data model.
Free Books - Here's a list of six free Data Science books that you can download and read this summer. The bonus book includes a Excel data cleaning template. (Level - Int/Adv)
Calculators - Without the Great Calculator Race of the 1970s we wouldn't have iPhones. Or spreadsheets - Dan Bricklin competed with calculators when he built VisiCalc (video 3:10 mark). And have you tried Excel's built-in calculator/converter? (Level - All)
While walking home last week, I saw this scary face in the sidewalk. Someone has marked the broken parts, so I hope it's repaired soon. In the meantime, that face is probably causing nightmares for the neighbourhood children (and me!)
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2019/20190430ctx.html
I'll also post any article updates or corrections there.
That's it for this week! If you have any comments or questions, send me an email.
[email protected] gmail.com
Last updated: April 27, 2019 11:26 AM