Support for Office 2010—and Office 2016 for Mac—has ended: Here’s what you need to know
On October 13, we marked the end of support for Office 2010 and Office 2016 for Mac. This means that we’ll no longer provide technical support, bug fixes, or security updates for these products, and organizations that continue to use them may face increased security risks and compliance issues over time. The requirements for connecting to Office 365 services have also changed—and customers will now need Microsoft 365 Apps, Office 2019, or Office 2016 to connect to Office 365 services like Exchange Online and SharePoint Online. While we will not take any active measures to block legacy versions of the Office client from connecting, these older clients will fall out of step with the service enhancements and may present performance and/or reliability issues over time. Read the full announcement of these changes here.
Pivot Table Help - Counting multiple items in a cell individually
Hello, I need some pivot table help. I’m using Excel 2010 and have scoured google for an answer without success. I currently have a table that looks like this (sample): Office Client ID Requested Funds Central X8345987 Mileage Parking Northern X435786 Parking Western U92345987 Mileage Car Insurance Central G3405695 Parking Mileage Car Insurance I have the office, client ID, and funds requested. In the funds requested column I used ALT + Enter to list multiple items in the one cell. The problem is, when I create a pivot table, this is what I get: Count of Requested Funds Column Labels Row Labels Mileage Parking Parking Mileage Car Insurance Parking Mileage Car Insurance Grand Total Central 1 1 2 Northern 1 1 Western 1 1 Grand Total 1 1 1 1 4 What I want is excel to separate the list items, and count them individually. For example, instead of providing a count of 1 for mileage and car insurance together, I want a count for mileage AND a separate count for car insurance. I want my pivot table to look like this: Office Mileage Parking Car Insurance Central 2 2 1 Northern 0 1 0 Western 1 0 1 Can anyone help me do this? Or is it even possible with a pivot table? Thanks!
Summing a row of drop down lists VALUE error
Hello all, I am trying to sum a row of cells where each cell has a drop down list created through Data Validation using Excel 2010. Each list has 2 options, a blank cell or a time that is formatted in the custom format h" hrs "m" mins". For some reason when another user chooses the options from the drop down list, the formula that sums the cells presents a #VALUE error. The summing formula is =TEXT(L14+M14+N14+O14+P14,"hh:mm") and I have attached the sheet to this message. I'm thoroughly stumped as to why when others view and select from the drop down lists, the answer that is given is no longer recognised by the formula. The perfect solution would be that the formula gives out a time in either hh:mm or the above custom format, but any advice is much appreciated!Format Date in header
Dear Ladies and Gentlemen, could you please help me with the header position? I want to use a picture (company's brand name) on each sheet for printing the document from Excel. Is it possible to allocate it (Graphic image) for the whole width of the page instead of left side/middle/right side? I would be very glad for your help!
