GetPivotData deactivation in Excel for Mac (Version 15.13.3)
Good morning community! I recently had Excel for Mac installed and I'm looking where to deactivate the "GetPivotData" function (basically, because it's annoying). I used to know how to do it in Windows based computers but I can't seem to find the right place in my Mac to deactivate it. In Excel for Windows, you can customize options in the "File" tab. However, that doesn't seem to be the case for Mac (I tried to attach an image of my screen but it's not letting me post it). Any and every helpful reply is appreciated 🙂 Diana
Mac OS Catalina | Excel & PowerPoint Refuse to Open
I recently upgraded to Mac OS Catalina. Ever since the upgrade Microsoft Excel & PowerPoint refuse to open up files in my desktop or documents folder after my computer has gone to sleep/idle status. The only way to get it to open is to restart/reboot my computer. I've completely removed Office and reinstalled it with the latest version without any success in resolving this issue. Any thoughts?
Excel was running very slow
I am using Microsoft Excel for Mac Version 16.26 as part of office 365 subscription. I maintain invoices of my business into one spreadsheet with many different sheets as they reflect vendors. I do calculations on each item about my expenses and selling price. Each sheet has many invoices and corresponding calculations. Lately I am seeing whenever I add a row or touch a cell or scrolling the sheet it is taking lot of time and showing as "Application not responding" Especially some of the sheets even slower. I did my research and I couldn't find any solution to resolve this. Can anyone from the community help me out how to fix this issue ? Appreciate help on this.
Help with drop down box and links to pages in same workbook
Good afternoon all, I am trying to create a drop down list in excel that will contain links to worksheets in the same workbook. I have 28 worksheets in the same workbook and it would be nice to be able to select which page I want to work on from a single drop down list. I am using office 365 (excel for mac) on a macbook pro. Any help will be greatly appreciated. Thank you in advance.