1,801,690 questions

Sort by: Updated
Updated Created Answers
1 answer

"office can't rename or move files stored at this location" and Upload blocked. MAC

Hey :) In some folders in our sharepoint, we will get this on every document we edit or create. Everyone in our company experiences the same. Anyone else seen this?

Microsoft 365 and Office | OneDrive | For home | Windows
asked 2019-05-03T10:41:17+00:00
Anonymous
3 answers

Null values in Microsoft Access Tables and Queries

I am playing around with a database where I if have records reflecting traffic volumes on roadways. On certain records, information is encoded into each link for traffic flowing in both directions of travel. If A and B are to locations, there is data on …

Microsoft 365 and Office | Access | For home | Windows
asked 2019-06-08T00:20:09+00:00
Anonymous
4 answers

SPO fault: Document Library view displays blank page - affecting multiple tenants

We are exeriencing a problem that seems to have been reported a number of times over the last month or so. A thread opened in December shows that at least 3 other companies are having this issue right now. Issue: When users go to a document library the…

Microsoft 365 and Office | SharePoint | For business | Windows
asked 2020-01-10T17:01:08+00:00
Anonymous
5 answers One of the answers was accepted by the question author.

I cannot delete file from my sharepoint

I am using Sharepoint online with a 25Gb limit.  My Sharepoint is currently full and I'm trying to delete files to make space but I am unable to. The error message "This site has exceeded its maximum file storage limit. To free up space, delete…

Microsoft 365 and Office | SharePoint | For business | Other
asked 2019-07-23T03:21:26+00:00
Anonymous
5 answers One of the answers was accepted by the question author.

How can I calculate the number of tax years between two dates with a working example

How can I calculate the number of tax years between two dates with a working example

Microsoft 365 and Office | Excel | For home | Windows
asked 2019-06-10T15:04:59+00:00
Anonymous
13 answers

OneNote for Ipad - Briefcase/lock icons on Notebooks

I use Onenote for Ipad. I have Version 16.30.1 (191017).   There are now briefcase/lock icons on all of my Notebooks.  What do these mean? Moved from: OneNote / iPhone & iPad / Office Mobile apps

Microsoft 365 and Office | OneNote | For home | Windows
asked 2019-10-23T14:06:25+00:00
Anonymous
4 answers

Planner not saving updates

I use MS Office 365 Planner and noticed that many times the tasks I added or the checklist items added to a task disappear (sometimes within a minute or two).  Is anyone else having this issue?  My tech support says to "clear the cache", which…

Microsoft 365 and Office | Subscription, account, billing | For home | Windows
asked 2019-08-21T18:27:32+00:00
Anonymous
2 answers

OneDrive taskbar is greyed out and set to on but not displaying in my taskbar- this is my personal onedrive

I have Personal OneDrive account and I need to stop syncing all my files, the instructions refer you to the taskbar icon that is not displayed and I can't try disable and re-enable as it is greyed out. Other forum suggestions say to re-install using the…

Microsoft 365 and Office | OneDrive | For home | Windows
asked 2020-01-10T13:12:38+00:00
Anonymous
6 answers

Furigana on Kanji only

I am using Office for Mac 2019 with a Japanese keyboard. When I type Japanese and apply Phonetic Guide on the Japanese words, Furigana appear not only on Kanji but also on Kana, arranged evenly above the whole sentence. If I try to take out the…

Microsoft 365 and Office | Word | For home | Windows
asked 2019-12-13T05:54:21+00:00
Anonymous
17 answers

Conditional formatting

How to get excel to dynamically format cells based on their content. The content is formatted as time (hh:mm:ss) For example I want all cells with a value of less than 6 hours to be red. None of the options I can find on the internet work

Microsoft 365 and Office | Excel | For home | Windows
asked 2019-09-03T06:54:44+00:00
Anonymous
3 answers

Excel office 365 xlsm workbook with VBA code takes 5 min to open and save

I have been creating a workbook with about 7 sheets and several hundred formulas from complex IF statements to OFFSET calculations to change the list size of a data validation for 30 different drop down cells. I also have VBA code to clear certain cells …

Microsoft 365 and Office | Excel | For home | Windows
asked 2019-06-19T22:32:55+00:00
Anonymous
0 answers

Pictures, Screenshots disappears from Excel, Word documents

After switching from Windows 7 to Windows 10 (Excel 365 for Business) I can’t see or insert any pictures, screenshots

Microsoft 365 and Office | Excel | For home | Windows
asked 2020-01-09T16:15:11+00:00
Anonymous
5 answers

Excel VBA - remove duplicate data from a row

Hi I have a sheet of data I would like some VBA code to go through each row and where date from column d onwards has duplicate cell values it deletes that cell and shifts everything left. How may I do this please? Thanks for the help.

Microsoft 365 and Office | Excel | For home | Windows
asked 2019-08-02T14:36:33+00:00
Anonymous
13 answers

Excel - Set up due tate with frequency as a data

Hello dear excel professional team, I would like to get some help on solving an issue that I cannot figure it out. I am building a training log and I would like to identify the due date for training having the frequency as my identifier for the due…

Microsoft 365 and Office | Excel | For home | Windows
asked 2019-04-10T16:45:42+00:00
Anonymous
8 answers One of the answers was accepted by the question author.

SharePoint - Unable to share folders

Hi   Does anyone know why I cannot share a folder with users outside my organization but I can share individual files or the entire document library?  Thanks

Microsoft 365 and Office | SharePoint | For business | Windows
asked 2019-04-05T19:19:19+00:00
Anonymous
5 answers One of the answers was accepted by the question author.

Office 365 Installation of file locations

I was today trying to copy in my personal macro folder to the normal location of XLStart on my Office365(Home) installation and found the path in a very weird spot under WindowsApps.  There are no files in the normal \appdata\microsoft\excel\xlstart…

Microsoft 365 and Office | Excel | For home | Windows
asked 2019-06-19T17:53:32+00:00
Anonymous
4 answers One of the answers was accepted by the question author.

Using Office 365 Exchange Online with on premises server and client outlook auto discover

Hey guys! I was wondering if any of you great guys could give some (much needed) instruction / advice! We're running Server 2016 on a Dell server in our small design studio, we each have laptops to connect to said server which is acting a domain…

Microsoft 365 and Office | Subscription, account, billing | For home | Windows
asked 2019-05-03T09:24:40+00:00
Anonymous
15 answers

Tracking External Delays

I have a task that started on time, but we were delayed for several hours because of the customer. This delay may cause a late finish for this task in the project. What is the best way to capture this? Create  a new Delay task and add the hours of delay …

Microsoft 365 and Office | Access | For home | Windows
asked 2019-06-11T19:35:35+00:00
Anonymous
2 answers

OneNote Android not Opening all Notebooks

I use OneNote on my laptop running Windows 10, latest build.  I am a Office 365 Business user.  All OneNote notebooks were created previously on the laptop.  I recently switched from Windows Mobile to Android phone.  No issues with accessing any…

Microsoft 365 and Office | OneNote | For home | Windows
asked 2019-12-22T16:08:30+00:00
Anonymous
2 answers One of the answers was accepted by the question author.

Word On MAC Compatibility

I recently purchased a MAC Air Book and downloaded MS Word 365 for my existing subscription.  I am having compatibility issues with a document originally created in Word and cut and pasted to the version of Word on my MAC.  The heading at the top tells…

Microsoft 365 and Office | Word | For home | Windows
asked 2020-01-27T22:24:46+00:00
Anonymous