![]() Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office Please try this method and check if it works for you and your Boss’s MAC system.Ĭonfiguration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. ![]() Intimidating because youre not exactly an Excel expert, and pivot tables have always had a reputation for being complicated. Powerful because it can help you summarize and make sense of large data sets. Microsoft does not guarantee the accuracy of this information. The pivot table is one of Microsoft Excels most powerful - and intimidating - functions. Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. You can find this workaround from this link: That way the data is only one series, but the slicer works to display only the data for each agency, so whatever formatting ![]() ![]() > Remove Agency from the pivot tables, and only connect the Agency Slicer to the charts. But you said >my boss usesĪ mac his computer can't run my macro. One of the workaround is to record a Visual Basic for Applications macro that saves the changes that you make to your PivotChart. As far as I know this is a known issue in Excel, and there is no perfect solution for it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |