Search results
1 lip 2016 · Question 1: Is there a PPT equivalent of Excel's VeryHidden for worksheets- where the user won't even see the extra slides while in normal edit mode?
It is data grouping / outlining. Check the Data tab/menu, specifically the "Outline" commands, group, ungroup, and subtotal. Search help for "group" or "outline". Outline (group) data in a worksheet at http://office.microsoft.com/client/helppreview14.
When you try to open a Excel workbook, PowerPoint presentation, or Word document on your mobile device, you might receive a message stating that the file is locked for editing by another user.
If you have locked the file yourself, it might be because the file is open on a different device, or the previous instance of the file didn't close properly. Tip: Sometimes a file may get locked if everyone editing isn't using a version that supports co-authoring.
In Excel, click the File tab. Click Options > Trust Center > Trust Center Settings, and then click External Content. There is only one option: Always block the connection of untrusted Microsoft Query files (.iqy, .oqy, .dqy, and .rqy) Check this option if you want to block connections to Microsoft Query files.
Follow these steps: If the worksheet is protected, do the following: On the Review tab, select Unprotect Sheet (in the Protect group). Select Protect Sheet to change to Unprotect Sheet when a worksheet is protected. If prompted, enter the password to unprotect the worksheet.
27 mar 2019 · I'm trying to automate a report from Excel to Powerpoint. I get the same error message. Sometimes the script works, some don't. I read something about "Panes" in another thread, but I didn't understand what to do with the info. The string causing the error is: activeSlide.Shapes.PasteSpecial (DataType:=ppPasteBitmap).Select.