Well I suppose I should thank Ted for pointing to one of my web pages that is now out of date in a link that is linked to what Ted linked to (all this indirect linking getting to answer irks me). At any rate, Ted indirectly sends you to one of my pages: On that page I refer to example queries to MSN, and these don't work any more because Dow Jones put the kabosh on these particular web queries. They want $$ for that data now. Excel on the Mac comes without the fancy little web browser that the Windows version has that lets you visually set up web queries. It seems to happen when a lot of processing power is dedicated to a built in query in excel or a large excel file is opened. Computer details: Windows 10 64 bit with 64 bit Office 2016 on Lenovo ThinkPad T440s and T450s, with Lenovo DU9019D1 docking station with dual monitors. Quickbooks for mac. Does Microsoft Excel 2016 for Mac fully support macros? What do you use Excel VBA for? What is the best way to learn Excel VBA (Macros) and to create How can I improve myself in VBA and Excel? When should one use Excel formulas and when to use VBA? How do I open Excel every day on time. On the Mac, you can use URL based web queries as described in the link. To the best of my knowledge the Yahoo examples should still be working. I think you should be able to refresh web queries made in Excel for Windows even though the fancy little web browser isn't available. The selection cursor must be somewhere in the query result set when you attempt to refresh the query either by right-click or from the Ribbon. I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support. To quickly and easily change the zoom in Excel, Word or PowerPoint simply hold down ‘ctrl’ key and scroll up or down using your mouse or trackpad. I thought I would post this keyboard shortcut here as it isn’t actually listed in the official but it isn’t intuitive and it took me ages to eventually figure it out. It also works in Word and PowerPoint (probably all Office 2016 apps for the mac). Surely I can’t be the only one who didn’t know about this keyboard shortcut or can I?:/ Update: Turns out a lot of people were searching for this! First off, yes it isn’t a true keyboard shortcut, you have to have one hand on the mouse, which isn’t optimal. Commenters have also pointed out that if you are using a mouse instead of the trackpad then you might find you have to hold down the control + option keys (ctrl + alt on newer mac keyboards) to use the scrolling zoom keyboard shortcut in Office. Otherwise scrolling when holding down ctrl alone may enable the OS accessibility zoom (akin to pinching with the trackpad). The other point to note is the inconsistent behaviour of Office apps: Word and Excel respond differently to PowerPoint. Scrolling down in PowerPoint will zoom in, but Excel and Word will zoom out. I have no idea why Microsoft have decided to create variation in their UI like this, but if anyone knows a fix please leave a comment!
0 Comments
Leave a Reply. |