1,828,649 questions

Sort by: Updated
Updated Created Answers
2 answers

Microsoft Office 2016 no longer showing?

I purchased a Microsoft Office 2016 Home subscription from a company called Clix-Distri in January 2020. However, it has stopped working. I temporarily purchased Office 365 later that year but uninstalled it with the help of Clix-Distri. However, I…

Microsoft 365 and Office | Install, redeem, activate | For home | Other
asked 2022-12-16T22:57:26+00:00
Anonymous
14 answers One of the answers was accepted by the question author.

Trying to get value if the cell to the right has specific value

I have a list of values two columns wide. I need a blank cell to return a value corresponding to the value from the list IF there's a specific value on the side of the blank cell (right, left, above or below, doesn't really matter). Let's say if there's…

Microsoft 365 and Office | Excel | Other | MacOS
asked 2022-11-16T15:48:07+00:00
Anonymous
3 answers

How to stop excel round off big figure at decimal part

Scenario 1: I have excel column A as Number with 10 decimal places. I have a figure 158675800298.42773 in notepad++ I copy this figure from notepad++ to excel column A column A displays the value as 158675800298.4270000000, the last digit 3 is…

Microsoft 365 and Office | Excel | For education | Windows
asked 2022-10-28T11:34:34+00:00
Anonymous
2 answers One of the answers was accepted by the question author.

OneDrive Email when shared link clicked

Hello all, I have a user that needs to share documents and folders from OneDrive and receive a notification email when the link is clicked. The previous person to do this job always received the email notifications but the new employee does not. I can't…

Microsoft 365 and Office | OneDrive | For business | Windows
asked 2022-08-31T16:01:11+00:00
Anonymous
4 answers

Loading 2-D Data Range into 3-D array – Seek VBA Solution

I'd like to read a range of data, say A1:J20, into an array, but I'd like it to be a 3-dimensional array, called 'ArrayData3D'.  I seek a VBA solution with minimized looping, and limited (?) in that the root data cannot be transformed into a…

Microsoft 365 and Office | Excel | For business | Windows
asked 2022-05-16T19:56:17+00:00
Anonymous
1 answer

Online Office Apps - Blocking

Dear Team, From POV of DLP Solution, we would like to block word /excel/powerpoint online office apps from their personal account, yet at the the same time Users should be able to access the office apps from business account. Below is the difference in…

Microsoft 365 and Office | Subscription, account, billing | For business | Other
asked 2022-08-12T06:25:29+00:00
Anonymous
1 answer

I'm having problems with copying and pasting

I'm hahaving problems with copying and pasting

Microsoft 365 and Office | OneNote | For home | Android
asked 2022-12-29T00:18:40+00:00
Anonymous
3 answers

Convert to Stocks Pop UP

I routinely use three letter abbreviations in my excel sheets. Today when I added them into Excel, "Convert to Stocks" pops up every time and I don't know how to remove that pop up.

Microsoft 365 and Office | Excel | For business | Windows
asked 2022-04-05T14:50:37+00:00
Anonymous
1 answer

When in preview mode for my Microsoft Form it is only showing the first 3 questions of 45. Is there any way to fix this?

I have tried using a different browser and resetting all branching. Neither of these things worked.

Microsoft 365 and Office | Install, redeem, activate | For business | Other
asked 2022-12-15T11:49:24+00:00
Anonymous
1 answer

Search box missing in PDF document opened in IOS Sharepoint App

Hi, I set up a Docuement Library in Sharepoint (M365) and I want to use the IOS Sharepoint App to open the documents on my iPad. This works fine so far. Now I am searching for a possibility to have search functionality within the opened document, but I…

Microsoft 365 and Office | SharePoint | For business | iOS
asked 2022-10-10T10:28:32+00:00
Anonymous
4 answers

Connection Blocked between two Excel files on OneDrive

I have two files in OneDrive and need to link them in formulas where one pulls data from the other but I am getting the connection blocked error. The help says to open the "Trust Center" from the options under the file menu, but there is no…

Microsoft 365 and Office | Excel | Other | MacOS
asked 2022-04-11T15:12:08+00:00
Anonymous
2 answers

change color of column and row identifiers

how do I change the color of the Column and row identifiers to coincide with the cell that the cursor is active on With Cell in B2 I would like the number on the left at 2 to be pink and I want the B at the top of the chart to be pink. How do I do…

Microsoft 365 and Office | Excel | Other | Windows
asked 2022-08-28T20:48:29+00:00
Anonymous
2 answers One of the answers was accepted by the question author.

Allow clients to open project file and edit it

Hi community, We have assign project licenses to our clients, and we always created our main project files in shared sites, but some of our clients use Mac and some users use windows, please guide us how to open or edit the such file at one time. Or can…

Microsoft 365 and Office | Project | For business | Other
asked 2022-10-13T07:19:11+00:00
Anonymous
5 answers

You cannot set permissions or open a file with restricted permission because an error occurred.

How Can I fix this I am the only owner of the File.

Microsoft 365 and Office | Excel | For business | MacOS
asked 2022-11-28T21:38:26+00:00
Anonymous
1 answer

How do I ACTUALLY keep source formatting when pasting in OneNote?

Hi I have searched for answers and I cannot find one! I have updated my settings for one note: Default paste option: Keep source formatting... But it does not work! I am using OneNote for Mac, Office 365, Version 16.64 2022. I am attempting to copy…

Microsoft 365 and Office | OneNote | For home | MacOS
asked 2022-08-21T01:49:19+00:00
Anonymous
1 answer One of the answers was accepted by the question author.

Lost access to sharepoint

Hi, We recently lost access to sharepoint. It was working before but now we are unable to access it. Is there anything we can do to restore this? [PII is removed by Microsoft Community Moderator]

Microsoft 365 and Office | SharePoint | For business | Other
asked 2022-08-08T07:22:39+00:00
Anonymous
8 answers One of the answers was accepted by the question author.

Sharepoint - How can I generate multiple folders in excel and use hyperlink to link them from excel to our sharepoint?

I will try to be as clear as possible. I want to make an excel and on some cells will be a text with hyperlink that when I press it will open the folder that is present in the sharepoint. All of this including the excel will be on the sharepoint. I…

Microsoft 365 and Office | SharePoint | For business | Windows
asked 2022-11-09T20:57:59+00:00
Anonymous
2 answers One of the answers was accepted by the question author.

One Document saved in multiple folders and editable in all folders

Is there a way to save one Excel document in multiple folders on OneDrive while retaining the ability to view and edit the document from each individual folder? Reasoning: I have 10 locations that all turn in reports weekly. These reports are each listed…

Microsoft 365 and Office | OneDrive | Other | Windows
asked 2022-09-28T12:45:31+00:00
Anonymous
6 answers One of the answers was accepted by the question author.

Save collapsed headings for other users - save collapsed state

I have a created a document with all headings collapsed upon opening the document. However, the headings only remain collapsed when the document is opened by me and not a different user (if I email myself the document and open it the headings are also…

Microsoft 365 and Office | Word | For home | Windows
asked 2022-07-25T20:41:28+00:00
Anonymous
5 answers One of the answers was accepted by the question author.

OneDrive uploading files I deleted/moved on another device

I had to take my usual laptop in for repair and was using another backup laptop in the meantime. The repair took over a month, so I made a lot of changes to my OneDrive while using the backup laptop. Now that I have my usual laptop back, I'm syncing…

Microsoft 365 and Office | OneDrive | For home | Windows
asked 2022-12-08T05:20:12+00:00
Anonymous