When Excel starts, it opens multiple files
<Moved from Windows 7 | Programs to Excel for Mac; guessing at Office 2016> Every time I start Excel it opens multiple recent files that I've worked on: all of them files that I saved and closed before quitting Excel previously This means I need…
Microsoft 365 and Office | Excel | For home | Windows
Co-ownership in OneDrive for Business
In Box, we can assign co-owners of a file or folder, giving that person all rights to this item. Is there such a function in OneDrive for Business or is this handled elsewhere in Office 365?
Microsoft 365 and Office
Dependant Combobox with Data Validation using Dynamic ranges
Good afternoon, Hopefully someone can help me out. I've been spinning my wheels on this challenge for a couple weeks now and have yet to find a solution that will work for my application. Others seem to have asked the question on many other forums but…
Microsoft 365 and Office | Excel | For home | Windows
Error for VBA code "ActiveSheet.Copy"
I have Excel VBA code that has been running quite well up to Office 2013. However recently l put the same code (excel worbook) on a new laptop running Office 2010 and it fails at teh "ActiveSheet.Copy" command. the code is essentially copying…
Microsoft 365 and Office | Excel | For home | Windows
Access - Dynamically setting row source for a sub report
I have a table containing the names of tables in a column called TableName alongside descriptive information. I would like to follow the descriptive info with a subreport with a "SELECT TOP 5 * FROM <TableName>" which provides the top few…
Microsoft 365 and Office | Access | For home | Windows
Using MS Access VBA to insert a row into an Excel worksheet, between existing rows without replacing data.
I need help with some simple syntax. Most of what i find is more complex than i require and i cannot seem to be able to figure out how, within my VBA procedure to be able to insert a new blank row directly after the existing 2nd row, but without…
Microsoft 365 and Office | Access | For home | Windows
Stuck in OneNote sign in loop
I use the OneNote app on my tablet I used to use it on my Win7 PC but recently I rebuilt that machine and so had to re-download the program. When I tried to log in I could not remember my password so followed the steps to reset it. Then I logged in with…
Microsoft 365 and Office | OneNote | For home | Windows
Fonts in Office 2016 look jagged and terrible
I just upgraded from 2013 to 2016, and my fonts suddenly look horrible everywhere, even in non-office apps. They went from smooth to jaggedy. How do I fix this?? This is really frustrating. Thanks to anyone who can help.
Microsoft 365 and Office | Word | For home | Windows
Printing dark cell gridlines
I have just upgraded to the latest version of Excel for Mac and a spreadsheet I have used for years is printing out with dark gridlines - i.e. there appear to be borders around every cell. The problem only appears to be a printing one - in the document …
Microsoft 365 and Office | Excel | For home | Windows
Microsoft Office 2008 for Mac Service Pack 1 (12.1.0) digital signature invalid?
Hi, I downloaded Microsoft Office 2008 for Mac Service Pack 1 (12.1.0) to my MacBook Air and, when trying to install it, I get a warning message that stops the installation: Digital Signature cannot be verified. Download the package again and try…
Microsoft 365 and Office | Excel | For home | MacOS
With Word 2016 can you Show all documents in the same window?
In word 2010 I could combine all word documents so word would only take up one slot in the taskbar. I could switch between word documents within word with the Switch Windows button. I often have 5 or more word documents open, and this helps me. How can…
Microsoft 365 and Office | Word | For home | Windows
Single Sign-On, UPN's and primary email addresses
Hi all, I am in the midst of configuring my Hybrid deployment of Exchange 2010 and Office 365. I have got SSO and UPN's configured as per the deployment checklists, but I was wondering if anyone had some good Active Directory wizardry to help me create a…
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
Mac Word 2016 - Shortcuts with Enter/Return key not working
Hi, I was using Word 2011 for Mac where I get use to my shortcut for InsertPageBreak as cmd+return/enter key. In Word 2016 when I go to Tools > Customize Keyboard > Insert > InsertPageBreak and try to set "new keyboard shortcut"…
Microsoft 365 and Office | Word | For home | Windows
Creating new organisational relationship - [Get-OrganizationRelationship], ManagementObjectNotFoundException
When I open EAC, Sharing and attempt to add new relationship for (e.g.) contoso.com - I receive the error message: The domains $$$$$ already exist in another organization relationship. Domains can only exist in one organization relationship. To create an…
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
Create DNS A Records programmatically from Office 365
Hello, Now, after create a tenant and finish domain configurations, we add DNS A record manually. Is it possible to Create DNS A Records programmatically for a tenant. Any cmdlet or API I can use? Thanks.
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
Directory Mail Merge from Excel to Word Table - would like one field to be a Table Header
Hi, I am trying to extract data from Excel into a word table which I can do successfully using a Directory Mail Merge. However, for one of the columns in excel, I would like the data to appear outside the table only once as a heading rather than…
Microsoft 365 and Office | Word | For home | Windows
I can't find trust center in excel
I can't enable all macros in macros setting. I can't enable all controls without restriction and without prompting in ActiveX setting. In message bar I can't tick for never show information about block content.
Microsoft 365 and Office | Excel | For home | MacOS
How to transfer a file from Publisher to Word
How to transfer an existing file in Publisher to Word
Microsoft 365 and Office | Install, redeem, activate | For home | Other
Macro to run Descriptive Statistics
Good morning, I am trying to create a macro to run Descriptive Statistics from the Data Analysis Tool-pack The add-in is active in the workbook. The code I used is: Application.Run "ATPVBAEN.XLAM!Descr", , , "C", False, True,…
Microsoft 365 and Office | Excel | For home | Windows
Publisher 2016 printing problems
I used Publisher 2016 to create my annual Christmas Card. Been doing this every year since 2003. Last year I was still using Publisher 2010, but this year I upgraded. I am using the same PC which was last year running 8.1 but now Windows 10. Same…