Sharing in Excel Online in OneDrive - Pivot table slicers don't appear in Android web browser
I'm having a strange problem with Excel online, and here is my example sheet for you to try: https://1drv.ms/x/s!AhTZr-GdLCi2aRKYt60Nt5j7cT0 In a browser on a desktop computer (in my case Chrome) it looks like this, and the slicers work as they are meant to: However, when I open the same link on my Android phone (Samsung Galaxy S5, Chrome) the slicers don't appear, and there is no placeholder like you sometimes get when slicers don't render: Why are the slicers not displaying on mobile, and what can I do to fix the problem? By contrast, if you choose to open the file in 'Excel' on the mobile, which is the mobile Excel Android app as opposed to Excel Online... ...you get the following warning becase slicers aren't supported: It's all very confusing. What I don't understand is why slicers won't appear when viewed in browser on my mobile phone. On my Android tablet the slicers appear to work fine, using the same link! Thanks
Excel 2016 Workbook Printing Double Sided problem
I got a new Windows 10 computer. Previously, I have used Excel 2016 with no issues. What I need to do is print a workbook in Excel (multiple worksheets) double sided. For example, sheets 1-3 are on one tab, while sheet 4 is on another. When I print, I would generally click, "print entire workbook" which then takes my document from 3 pages to 4. Pages one and two print double sided no problem, but no matter what I do, pages 3 & 4 will not print duplex. Other than printing to pdf (which saves it, then I have to open that document and print from there which is a PAIN), can I print those 4 pages onto 2, or am I stuck? I have searched the internet to no avail. Thanks!View Previous Excel Spreadsheet Version in SharePoint Online without Restoring
Due to the new AutoSave option in Excel (which I've turned off by default) my colleagues are inadvertently making changes to Excel spreadsheets that they're essentially only trying to review. My guess (from speaking with them) is that they're just enabling certain table filters or slicers in the data, or perhaps resorting records as they review certain spreadsheets. However, I can't really be sure that no data has changed and that has me concerned. Ultimately, I want to compare their version with the previous version to review what has changed. While Microsoft Word for Office 365 has great mechanisms for doing this, understandably spreadsheets are a different beast and that sort of web-based comparison doesn't seem to be available yet. What I'd like to be able to do is take the previous version (download it if I have to) and compare it against the current version. And in the long-term I've reduced the permissions for the document library folder so more people have just "View" permissions but no "Edit" permissions. Here is a image of screenshots that shows what I'm running into. https://www.screencast.com/t/1bT6y33C0t Any help for a better workflow or suggestions on what we should be doing would be appreciated. This is pricing documentation and while I want people to quickly review it, I don't want any edits to be made unless they're reviewed by multiple people and approved.Share it: Embed an Excel workbook on your web page or blog from OneDrive
Sharing from SharePoint or OneDrive for Business? Go here. With your Excel workbook stored on OneDrive, you can embed it in your blog. Your readers can sort, filter, and calculate data, right there in your post. If you update the workbook in OneDrive, your readers will automatically see the latest in the embedded view. See https://support.office.com/en-us/article/Share-it-Embed-an-Excel-workbook-on-your-web-page-or-blog-from-OneDrive-804e1845-5662-487e-9b38-f96307144081
Mail merge
Hi, I am doing an IT level 2 course which involves learning mail merge. I am following all the instructions on the wizard but when I go to an existing set of recipients I do not have the expected pre prepared excel spreadsheet to use. Does anyone know where I need to go to get this and even why it isn't already there? I am using office 365 personal. Thanks in advanceProtected Sheet for field use...
What is the best process to make one sheet available for use by people in the field? They just need the ability to fill in form data, save it, then email it in. The layout is rather simple, with no charts of any kind. The reason for my inquiry is because we have been using PDF forms, but the iPhones are corrupting some of the form fields. Any ideas would be greatly appreciated.Shared Excel Workbook does not save all changes (Office 2010, Excel 14.0.7197.5000)
Hello, I created a shared excel sheet, where multiple users has access to. Now 5 people are working in this table and the document is stored on an network drive what could be used by all of them. If more than one person is working in the table and more than one change is made at the same time in most cases a hint pops up whether the changes of the former saver should be used or the newer ones. Unfortunately sometimes (not definable when) this is not the case, what creates greater issues. Even the change history does not provide any usefull hints regarding what was happen and why. Any ideas about that constellation? I would be happy for any advice. Many thanks in advance, Best regards!
Find and Replace not working in Protected Excel Workbook (for unlocked cells)
I have noticed a new issue in the desktop version of excel (v16.13.1) - I am working on Mac. I have a protected workbook with protected sheets and some unlocked cells which contain plain text. With the older version (before 2018) I was able to still use find & replace to quickly correct mistakes in these text cells, even though the overall workbook was locked (and sheet was protected) -The cells I want to be able to edit are unlocked and can be edited by clicking into them one by one. Since the new update, I can no longer use find/replace or the spell check option. I hope this is an update oversight and will be fixed soon!
