Questions tagged [office365]
A set of subscription based software services that require monthly or periodic payment of fees to Microsoft Corporation.
1,103
questions
1
vote
1answer
7 views
Is there a way to prevent Microsoft Word 365 from showing spelling suggestions on LEFT click?
A (recent?) new behavior of Word that seems to have come with an update (presumably to make the application friendlier to users working on tablets and such, who may lack a right-click modality) is ...
1
vote
0answers
18 views
VBA vs PowerAutomate protecting sheets
I had an excel files with 3 sheets Password protected in order to prevent data insertion in the cells out of the range I needed.
I wrote a VBA script to let the user have a button to add a line to a ...
3
votes
0answers
48 views
+100
Power Queries in Excel just default to “anonymous” and doesn't ask for login info
I have created multiple Excel sheets for my coworkers, many of which involve power query connections to our corporate SharePoint site. When I set it up, I logged into my SharePoint account to ...
0
votes
2answers
140 views
Microsoft Outlook hiding text after pressing enter [duplicate]
When typing an email, the previous line of text is hidden after pressing enter. Then, the cursor is stuck and can't be moved.
I've checked if it's deleting the text and it's not, since when sending ...
1
vote
1answer
44 views
What happened to “Suggested Times” in Outlook (365) windows app?
Suggested Times feature is missing as of a recent update in the Outlook -> New Meeting section - this was usually on the right side of 'room finder'
I have found these two recent articles I found ...
0
votes
0answers
24 views
How to change the default Office365 account?
I'm using Windows 10 Pro 20H2, and my Windows is linked to my "Microsoft Account" (I will name MyPersonalAccount@hotmail.com). I don't have Office365 subscription on this account.
Now I have ...
0
votes
0answers
9 views
Excel online workbook cache local file which is password protected - content.mso
We are going through the process of moving our files to sharepoint, a few of our workbooks are linked to other workbooks which are all password protected.
When I open Workbook 1 which is linked to ...
0
votes
1answer
42 views
Office365/Outlook's chat icon feature got disabled
update 2021-05-13:
after re-install msteam, the function works now.
On my company PC, it has Office 2016 preinstalled, on that, I could easily double click on chat icon in outlook to open a MSTeams ...
0
votes
0answers
21 views
AzureAD PowerShell - how to read CountryCode, DistinguishedName, middleName, msExchRecipientDisplayType, msRTCSIP-Line and other attributes
We are syncing on-prem AD to Azure AD using AzureADConnect and need to verify that the following attributes from on-prem AD are syncing successfully. Can you please help with the PowerShell commands, ...
0
votes
1answer
31 views
Outlook cannot synchronize after joining organization
I recently joined a Microsoft Teams organization using my personal (Microsoft 365) email address, and since then the Outlook app (Version 2103 Build 13901.20400) on my Windows machine has not been ...
0
votes
0answers
20 views
How to stop photos from moving around in text wrapping
How do I stop photos moving around in text wrapping. when I print out document, they have all shifted!
I am using Office 365, latest M/Word. I insert documents from my Pictures in my computer and ...
0
votes
3answers
159 views
“Client Error: Settings Conflict” when trying to add allowed domain to spam filter policy
I'm getting the above message when attempting to add one of our trading partners' domain to the Allowed Domains list for the Anti-Spam inbound policy in the Office 365 Security & Compliance portal....
11
votes
4answers
7k views
Spurious 0.0000000000001 added to formula result
My wife and I have a spreadsheet to work out our finances at the beginning of each month and this month has a strange figure in cell F9.
The formula in cell F9 is ="+ £"&-'Sue''s ...
1
vote
1answer
25 views
Outlook rule to delete emails older than stipulated number of days
While setting mail rules, I want to be able to set them and forget them. But, I have an issue with one particular rule where I am using a before datespan rule.
I have Before: ticked and specified a ...
0
votes
0answers
33 views
Paste a table from Onenote to Word without losing format
I have to paste a table from One note or Pages to Word 2016 but as i do that the format is not respected. There is extra space and the bullets aren't the same. There is no differences in the ...
0
votes
2answers
42 views
How to Search for an Exact Phrase in Outlook 365 Online Archive?
In Outlook 365 I want to search my online archive for an exact phrase. When I put the search term in quotation marks, I still get results that do not exactly match the phrase.
Searching for an exact ...
0
votes
1answer
60 views
Microsoft 365 E5 security add-on can't remove autofill email addresses in Outlook 2016
Microsoft 365 E5 security add-on blocks the ability to remove autofill addresses. Had a ticket open with Microsoft for 4 weeks about it and they could not resolve the issue. Any ideas?
Steps to remove ...
1
vote
0answers
17 views
Avoiding file replication in MS 365 products
I have an existing file/folder on my Onedrive. I would like to achieve the following:
Make this file/folder available in the "files tab" of a Teams channel or a shared Sharepoint folder ...
0
votes
2answers
40 views
SSL certificate authentication on Outlook 365 (cloud)
We can send emails using an Office 365 account from third-party devices using STARTTLS encryption on a SMTP server (port 587).
The device I am using does not support STARTTLS, only plain vanilla SMTP (...
0
votes
1answer
29 views
MS Word: Custom Text Fields that Update Each other
I know that the Custom Document Properties method exists, but it's a bit too clunky for me and the people I work with to use.
I want to create custom fields that work just like the built-in Document ...
0
votes
1answer
18 views
How to copy file directly from Google Account drive (not GSuite) into Office365 OneDrive
I am looking for the possible easiest way to backup my some of my Google data onto OneDrive.
On Google side I have free Gmail account, on Microsoft side I have OneDrive related to my Office365 "...
0
votes
0answers
29 views
Sharepoint Recycle Bin Searching
Helping out with (small) company IT. Everyone using Office365, Sharepoint, OneDrive. The level of tech savvy is not high among users. People often deleting files, which I then need to find/restore. ...
0
votes
1answer
21 views
MS Word insists on proofing in French
MS Word insists on proofing my entirely English document partly in French. Any word similar to a French word (e.g.: regional/régionale) is marked as incorrectly spelled. And when I right-click these ...
0
votes
1answer
14 views
Phantom heading entry and display issue in Word
I am using Microsoft Word and there is a phantom heading role at the end of the navigation pane. Usually, it is just an extra empty row with header style applied. However, it is not exactly the case ...
0
votes
1answer
41 views
Sending email to those who are members of the Office 365 group
Office 365 group is available. This group was created over Teams and has an e-mail address test@domain.com.
Since this group was created over Teams, it was added by an authorized member via Teams.
The ...
0
votes
1answer
29 views
O365 shared mailbox and message center
My Office 365 shared mailbox works great, but it keeps receiving emails from Microsoft regarding various updates from Microsoft 364 Message Center. The latest was about "Yammer" losing TLS 1....
1
vote
1answer
31 views
Windows 10: How to avoid MS Office to be started?
In my family there is a person using Windows 10 and a non-Microsoft office suite.
On the computer, there is some "Microsoft 365" pre-installed which is not "registered". This means ...
0
votes
1answer
9 views
Enabling office 365 logins on non-azure virtual machines
I'm kind of clueless here so please bare with my mistakes.
We are using Office 365 and our user accounts and resources seems to be listed in the Microsoft 365 admin page (and it looks like there is ...
0
votes
1answer
34 views
Separate taskbar shortcuts for Outlook Web Mail and Calendar
Using Chrome or Edge you can install Outlook (from Office 365) as a PWA / taskbar icon. However, it will always default to the Mail section of the Outlook PWA. Is there a way to add a second icon to ...
1
vote
1answer
25 views
Get embedded hyperlinks from cells using INDEX
I have a cell with =INDEX(D:D;$E$1) which spits out various part numbers. 90% of time the result is a hyperlink taking employee to our supplier website.
In google docs search results come in form of ...
0
votes
0answers
20 views
Diagnosing an email bounce from a free Gmail business domain
I have an email address associated with one of Google's free business domains for my former employer, a nonprofit public interest research group. The organization went bankrupt about a decade time ago....
0
votes
1answer
29 views
Get cells from another sheet based on criteria
I'm trying to build a simple helper to control my expenses.
One sheet has a list of all financial movements (income and payments), with these details:
Date
Amount
Reason
02/02/21
-1000.00
Rent
02/...
0
votes
1answer
21 views
Microsoft Word 365 Content Controls Tab Order in Text Box
I am trying to create a template with content control fields and some text boxes in fixed positions using the newest Microsoft Word 365.
The content controls themselves work fine but when using the ...
1
vote
1answer
36 views
How to set the background colour of the rows in a spreadsheet depending on the value of a cell in the row
How can I say,in Excel on the web: If cell F2 contains "Completed", set the background colour of row 2 to red?
There are lots of articles online (e.g.1, e.g.2) but they all seem to refer to ...
1
vote
0answers
81 views
Outlook 365 - unable to cancel meeting that contains delete distribution list as attendee
I'm trying to cancel a meeting and am receiving the error "an internal support function returned an error". The meeting has a deleted distribution list as an optional attendee, which I am ...
1
vote
1answer
525 views
How can I change my initials in Microsoft Teams?
In Microsoft Teams, in a meeting, for all logged in users their initials are shown. We're a rather small company but I have common initials and there's another colleague in my company who shares my ...
0
votes
1answer
12 views
How do I set an Outlook rule on bulk email?
My company gets lots of bulk email where the "To:" field and "From:" field are identical so the Sender and Recipient match. My email address, along with many others are hidden in ...
0
votes
0answers
27 views
Microsoft Word's “keep source formating” doesn't work, but pasting as an image works perfectly
I need to add cataloging info to my manuscript which will be printed. They gave me this online website where I can generate the cataloging sheet according to their standards etc. But it generated a ...
0
votes
3answers
41 views
Logging into Office365 Exchange via Powershell, from scratch
I've tried to do so from a plain, newly installed powershell with nothing else installed on top, but the official way simply seems to lead to errors about missing package managers, not-existing ...
0
votes
1answer
33 views
Planning assistant is greyed out. office 365 - outlook
Hello. All the Super users.
THE PROBLEM:
Our assistant can not see someone's calendar in planning assistant they are greyed out, while she can see others' calendars just fine.
In the calendar overview,...
0
votes
0answers
36 views
Unable to Remove Custom Outlook Web Add-In
I'm developing a custom web add-in for our organisation, for outlook. I'm office 365 admin and uploaded the manifest in the office admin portal/center. I only made it available for myself, during ...
0
votes
0answers
39 views
EXCEL: Can I reference text within a cell, for a file path, in a function?
I have the following VBA module in Excel which allows me to do check if a file exists in a given folder:
Function FileExists(FilePath As String) As Boolean
'Declare variables
Dim FileName As ...
0
votes
0answers
41 views
Setting a forward rule on an out of office in exchange online
For as long as I know, we've been able to set some rules on the out-of-office settings page in the outlook application. That's mostly used to forward the mails during that period of time. That's fine ...
0
votes
1answer
91 views
Excel 365 co-authoring: how to track changes?
I would like to see who changed which cells in Excel 365 workbook shared for co-authoring.
Something similar that was available for shared workbooks like this:
Is that possible somehow?
1
vote
0answers
38 views
Outlook offline, rest of PC online
One of my users has a weird problem. He's not aware of one specific thing that's changed to make it start.
Outlook, after he comes in from using his machine at home reads offline. It's not in Work ...
0
votes
1answer
23 views
Eliminate Excel Only “Got It” messages
How do I stop all Microsoft Excel online "Got it" notifications?
Example showing Browse Version History "Got it" message.
Clicking on Got it or the close button has the same ...
0
votes
0answers
10 views
Is it possible to prefill new pages with data/text?
When I open Excel in "Page Layout" the first page is active. All other pages are greyed out. To activate the greyed out pages, I have to click and add data.
My question is:
Is it possible to ...
0
votes
1answer
82 views
How to change the Update Channel for Microsoft Office 365 Apps?
I want my users to be on the Semi-Annual channel that updates every 6 months for stability. For my own system I want to be on the current version of Office so I can get all the new features and work ...
0
votes
0answers
17 views
change python executable used by “RunPython” command in ms excel macros
I have a subroutine like this in MS Excel:
Sub xxxx()
...
...
RunPython ("xxx xxx; xxx.xxx()")
...
...
End Sub
I would like to change the default python executable that ...
0
votes
1answer
51 views
How do I disable microsoft office updates?
I have a licensed copy of office 2007, but after installing it on my new laptop I'm apparently forced to update excel (and, I imagine, the rest of office) to office 365.
I don't want to. I want to use ...
