Questions tagged [office365]
A set of subscription based software services that require monthly or periodic payment of fees to Microsoft Corporation.
1,463
questions
0
votes
1
answer
18
views
Outlook calendar peek (side view) does not include events from all accounts
I'm using Outlook (MS Office 365 for Small Business) on Windows 10 Professional. I have set to show calendar peek (in right side view). This works as expected, but only for my primary mail account.
...
0
votes
0
answers
28
views
Microsoft Teams login problems after moving client to different computer
I have a client that is having login problems with her Microsoft apps after moving her to a newer computer. It is mainly problems with Teams. It will give errors such as "cant connect to ...
1
vote
3
answers
49
views
Countif number matches pattern in excel
How can I count the number of cells in a column that start with a specified prefix of 3 characters, and have a total length of 6 characters?
E.g. for the column
123000
123001
123002
546000
1230101
...
0
votes
1
answer
21
views
How to discern the location of a file/tab in Microsoft Teams from the tab's URL
I have a situation where someone has added a tab to a team in Microsoft Teams, and the tab appears to lead to a file... except the file is not one that is hosted/stored within that Team. The issue is ...
0
votes
0
answers
21
views
Intune - Using custom attributes with macOS devices in for Compliance Policies and Conditional access
I am trying to figure out if this is a use case in InTune, but have not found a way to do so. I have a set of attributes that I am pulling as custom attributes from macOS devices which I would like to ...
0
votes
0
answers
10
views
how to select blank cells in excel 365?
How do I select blank cells in Office365 excel?
The Go To Special option is not there
When i find blanks in excel application, I use Go To special like this:
But when I am using excel 365 I am ...
0
votes
1
answer
36
views
Adding Description fields in Active Directory for Outlook Contacts
there is a request to add a filed in the active directory specially the description field to
a created field in the contact card for all employees in the Address book for Exchange online & on-...
0
votes
0
answers
15
views
Cursor keeps jumping to the top of the email in Outlook 365 online on mobile devices [migrated]
In Outlook 365 through web browsers, if I pause typing an email for a moment, the cursor will jump to the top of the email in front of the salutation. This has been happening for years every time. Not ...
0
votes
0
answers
28
views
How to pick Office 2016 license in Click-To-Run installer?
The context: I have two active licenses purchased in my MS account, Office365 subscription and Office Home and Student 2016.
Both allow installation and when I press the install button they start ...
4
votes
1
answer
215
views
Does changing the MX records on Tucows DNS affect POP/IMAP?
Scenario: My company have email hosted by the ISP with a business domain. The DNS is hosted on Tucows. I have full access to the DNS. The ISP emails only work as POP3 or IMAP.
I want to migrate to the ...
0
votes
1
answer
76
views
Trying to set up a exchanger formula in MS Excel
I'm working on a spreadsheet which helps me reformat data to include certain criteria based on Intellectual Property.
In my excel I have column A which includes a Country that indexes to column L and ...
0
votes
0
answers
29
views
Within a M365 Tenant, Is There a Setting to Disable All Tips Globally Once and for All?
With Microsoft 365 tenants, tips just keep popping up everywhere, all the time, through apps (web and desktop versions) and all the admin centres. This is especially crazy with a new account: the ...
0
votes
1
answer
57
views
How to make document dimensions match printouts
I would like to be able to specific dimensions in MS Word (*) and have them match in the real world. This seems straight forward, but when I try this they don't match.
A minimal example is an empty ...
0
votes
1
answer
205
views
Any way to allow multiple people to edit a coauthored, password protected workbook, at the same time?
I am currently working on a sheet that I want select people to have full access to, while everyone else without the password for the sheet cannot. I can do mediocre and overly complicated solutions ...
2
votes
0
answers
27
views
Disable Windows 11 data collection across an entire tenant for O365 Enterprise?
I'm at my wit's end with how much Windows 11 is sending back in terms of information used for "personalized ads". The security policy I need to adhere to is very IP protective and basically ...
0
votes
2
answers
50
views
Equivalent of "Styles" pane in Word for Mac
It is surprisingly difficult to find a definitive and up-to-date answer to my question: Is there an equivalent of the MS Word for Windows 365 "Styles" pane for MS Word for Mac 365? This is ...
0
votes
0
answers
39
views
Word file icons are blank
I'm using Office 365. And I noticed that the Word file icons are blank. Excel, Powerpoint, and others are ok.
I've already tried reinstalling and modify the default applications. Nothing fixed the ...
0
votes
1
answer
606
views
Emails getting a “Relay Error 550 5.7.367” on Office365
I am working on an odd issue that is occurring over the past few days with receiving undeliverable email errors. The error is 550 5.7.367 ("<email> is not authorized to relay messages ...
0
votes
2
answers
2k
views
New Outlook doesn't allow me to sign in to shared mailbox
In the classic version of Outlook I was loged into my personal mailbox and I also added a shared mailbox that we use together with colleagues.
After switching to the New Outlook I got a prompt that I ...
0
votes
0
answers
47
views
Excel, reference header row instead of column in xlookup formula?
I need to make an Excel spreadsheet template that merges customer data from two other Excel files that are downloaded from a vendor application each morning. The files have a customer ID number for a ...
-1
votes
1
answer
141
views
Why do Office 16.x installs create "Microsoft Office 15" and "Office15" folders in $PROGRAMFILES and its subfolders?
My laptop has Microsoft 365, and has never had Office 2013 installed on it. But it does have a C:\Program Files\Microsoft Office 15 directory as well as the expected C:\Program Files\Microsoft Office.
...
0
votes
1
answer
73
views
Evaluate returning #VALUE? when trying to calculate large VSTACK
I am working on a project that is pulling a bunch of spilled data across a ton of sheets that are all in the same spot as the sheets are based off of a template.
Using the name manager I was able to ...
0
votes
1
answer
58
views
Block Adobe Add-Ins in Office365
Every time I remove the Adobe add-ins from my Office365 applications, they eventually reappear. Since Adobe updates automatically, it's apparent that the updates are the likely culprit.
I can't find ...
5
votes
1
answer
535
views
Making it so users that do not have macros enabled cannot see other sheets
I am working on a project that wants all users to have macros enabled. It is a shared sheet so I cannot simply hide everything as a baseline and unhide the sheets when Open_Workbook is ran. My goal is ...
0
votes
1
answer
50
views
Can I prevent Outlook 365 from removing recipients from attached email file?
There's a process at work where I build out email messages for other people programmatically, then save each email as an .msg file, then email each file to the appropriate person. Each of those people ...
0
votes
0
answers
55
views
Any way to disable the Accessibility Checker on a Workbook
I am working on a project that for security reasons needs to have the accessibility checker disabled. Although through settings I can disable it on my excel, I need to find a way either through VBA or ...
0
votes
2
answers
200
views
Making a workbook only able to be opened in the excel desktop app
I am working on a project that requires all of the users on it to be on the desktop app for sheet security reasons. The sheet security can be bypassed by simply not having VBA run by opening the sheet ...
1
vote
0
answers
323
views
Why do I keep getting this "Subscription expired" notification Microsoft 365 in Windows 10?
I keep getting this notification in Windows 10. It claims "Subscription expired", but my Microsoft 365 subscription is definitely not expired, and neither is the card registered for the ...
0
votes
1
answer
246
views
Creating a VSTACK'd array from a changing list of spilled references
I am working on a project that requires a large 'pool' of data to pull from and sort from. To keep the workbook efficient, the data is kept in sets of SPILL's, as pulling a raw selected range for the ...
1
vote
1
answer
33
views
How to plot data from separate files and axis intervals onto one chart?
I am running a simulation that exports data as a csv file(things like elapsed time, energy etc).
I have a few million rows of data (but only 5-6 columns), meaning I cannot actually open this file in ...
0
votes
2
answers
408
views
Can't work with Outlook 365 IMAP account that has this message "Message store has reached its maximum size", no scanpst.exe
I have a Google Workspace Business Standard account configured by IMAP on Outlook 365 on a Windows 10 Pro machine.
Outlook says that "Message store has reached its maximum size" and I can't ...
0
votes
2
answers
184
views
Microsoft Outlook 365 - Home Ribbon - Stop labels from showing and hiding when changing messages
I am using the Microsoft 365 version of Outlook (Microsoft 365 Apps for Enterprise, VErsion 2310, Build 16924.20150 Click-to-run, Current Channel) on a Windows 11 computer.
I notice that depending on ...
1
vote
2
answers
126
views
Excel 365 - retain all changes to a file beyond 60 days
Our order review process requires that we be able to tell when a company rep has corrected or changed anything on an order form. The order form is currently an Excel 365 spreadsheet.
A recent revision ...
-1
votes
1
answer
101
views
wrap text feature in Excel changed / inconsistent behaviour
Excel's "wrap text" (german: Textumbruch) behaviour seems to have changed.
Whitespace at the end of the cell used to be cut off (not transferred to the new line) if "wrap text" is ...
0
votes
1
answer
38
views
Is there a technical reason for having Office 365 on my PC?
I noticed a few days ago, that the system installed Office 365 on my Windows PC. At the start of the process, I thought it was updating my Office 2016 installation.
The reason I haven't upgraded my ...
0
votes
0
answers
55
views
How do I fix Excel instability after using PowerQuery?
I've been working on some VBA code to import and parse PDF files using PowerQuery. The code itself is working fine, but after some column-related errors (I had more columns defined than some of the ...
0
votes
2
answers
181
views
What setting in M365 would prevent a user from being able to use Add-Ins for Outlook?
A number of our users are unable to use Add-Ins for Outlook. They're the modern type add-in that should work both in the web browser and in Outlook desktop client.
There's a button in Outlook ...
1
vote
0
answers
14
views
With Office 365 Excel Online, Edge iPadoS 17.1.1, how to reference this Workbook from separate Workbook? [closed]
I need help to reference separate Workbook using Excel 365 Home Online on ipadOS 17.1.1.
Following steps worked for Windows desktop but not in with Office 365 Excel Online.
open two instances of ...
0
votes
0
answers
49
views
Need Help Preventing Excel from Auto-Transforming CSV Column Data
I'm encountering an issue when opening a .csv file in Excel it automatically transforms some data in it from string to number and it ruins the data.
Currently the CSV looks like:
names,Ids
John,Adam,...
0
votes
0
answers
127
views
OneNote freezes?
I've got a user whose OneNote freezes everytime they use the interactivity of a SMART MX075-V3 smartboard. They have nothing running in the background. The version of OneNote that they use is ...
0
votes
0
answers
82
views
How to disable Ctrl+T taskbar hide hotkey?
On Windows 11 I want to disable the Ctrl+T hotkey that hides/shows the taskbar so that it can be used to open new browser tabs instead. It seems to be a problem with PowerPoint; I am currently running ...
0
votes
1
answer
424
views
Can I add domain for Microsoft 365 Basic subscription? [closed]
Ì'm thinking of moving my domain from Google to outlook.com and I'm confused if it will be allowed to add domain to my subscription or if it just is for outlook.com users.
Add an existing domain to ...
1
vote
1
answer
152
views
Office 365 - how to remove buttons at the right of the menu bar
In Office 365 (Word, Excel, etc.) there are a number of "action buttons" to the right of the menu bar (see example from my German Excel - "Kommentare" and "Freigeben").
...
1
vote
1
answer
71
views
Remove spaces in table cell
I am using MS Word I need to display two pictures next to each other. For this I created the table shown in the image below. However, I cannot find any way to fit the image to the table cell. I have ...
1
vote
1
answer
83
views
How to map a OneDrive Folder -> to a Teams File Folder
Situation:
I have a shared OneDrive Folder with Project Files in it:
want to be able to map this folder to a Teams Channel File Folder
Goal is to be able to edit files in OneDrive by accessing them ...
0
votes
1
answer
771
views
Can't Assign Outlook Retention Policy
We have a [email protected] email account which we use for our apps and services for sending emails to clients. Last week, all the emails stopped going out because the mailbox was full (...
0
votes
1
answer
111
views
Setup an alert email for multiple similar inbound emails within a short timeframe
Don't know if this is the right place for this question. But hopeful for some answers or ideas.
The situation:
We set up some forms that send us emails on multiple website with support questions.
So ...
-1
votes
1
answer
1k
views
Best way to embed calendar invites links in the body of an email
We use Microsoft 365.
One of our departments wants to send emails to people outside our organization. The body of the emails will contain a lot of information about different meetings and activities ...
0
votes
1
answer
220
views
Dynamic Array Subtotal that changes its column sizes without using VBA or volatile functions
I need to make a dynamic array subtotal that changes its column size by another dynamic array. The example sheet, challenge, conditions, and attempts I've made are below.
[Example Sheet]
Challenge:
...
0
votes
0
answers
130
views
Sharepoint/OneDrive - how to exclude a folder from search?
I want to search in OneDrive (online, using Browser). But as I know, this is in fact a Sharepoint.
How has the search string has to look like to find only those files in my documents, that are not ...