Microsoft 365 and Office

I have a very long nested IF and IFS formula that works fine.However, if I go back to it and change anything, even just a number, it displays text and not the result.The cell format doesn't change, it is not set to display formulas - the only difference is I changed 12 to 13.good formula displays result=IF($J11="bicycle",IFS(AND($L11>=14,$L11<17),12,AND($L11>=16,$L11<20),14,AND($L11>=18,$L11<22),16,AND($L11>=22,$L11<25),20,AND($L11>=24,$L11<28),24,$L11>=28,26,$L11="",LISTS!M$13),"")formula displays as text now after changing bold number=IF($J11="bicycle",IFS(AN

I'm working on a years-old existing document and it has a Table of Tables. I have added tables and the Table of Tables won't update. (Yes, I have used the insert table feature). I can only add a table of contents, Table of Figures, or Table of Authorities. How do I update/add a Table of Tables? Thanks!

Hello,I am using excel as normal and suddenly without changes i know off when i open excel file i get the error "There was a problem sending the command to the program".I have tried the following and still does not work.Reinstalled Office Pro Plus 2016 EN SVR2016 .Disabled DDE through regedit, as Excel would not open to allow us to change DDE settings from the options menu.Tried to run in safe mode but excel still wouldn't open or at least check in task manager that it tried to open for few sec and closed itself without any windows open or error.Issue happens to all files or even ne

something is broken. cant renew my subscription so I am locked out of everything. Crappy timing as I have deadlines today.

I'm trying to work through a sheet that I'm using to do per unit inventory. I have a stats column, and I need specific cells to show a number of how many rows a specified term is used. such as how many times I mark the device type as "LAPTOP" or "IPAD". How could I go about achieving this?

Hi,There are two One Drive accounts on my Mac, one for personal and one for work. I would like to know how to delete the personal One Drive and remain only the one for work. Thank you very much.

My shared folder has been missing from the file explorer. Up until yesterday, it appeared as folders on my PC alongside the other folders belonging to my OneDrive account. Now, these folders that are shared with me appear as shortcut links instead of folders on my PC.This has happened to 2 different PCs, which are all connected to the same OneDrive account. I have uninstalled OneDrive, cleared the cache, etc, and reinstalled it.. I've removed shared folders, had them unshared by the owner, reshared back to me, and then added them again to My Files, but this didn't work either.

Since yesterday, when I right click Excel or Word in my Start menu (W10 22H2, Office 365) I no longer get my (vital!) lists of pinned & recent files but instead the right-click dropdown offers options 'Unpin from Start/Resize/More/Uninstall' - how do I display my pinned/recent file lists again instead?

I've created an Excel check register. I want to automatically add or subtract new entries so my balance is updated without me doing the math every time

I have tried contacting Microsoft support however I cant there is no direct way or even email to contact Microsoft support, I tried calling the AU number 5 times now I go through the automated steps and just goes blank for a few minutes then hangs up.I unfortunately go through a third part and I dont want to go through their support as the payment is directly through Microsoft so I end up in massive loop to try and contact Microsoft support.Any help would be appreciated.

Hello,I'm having an annoying problem. In the past, everything worked fine, but for a while now, it has stopped functioning properly.When I edit a .txt file on OneDrive web and then save it, I always receive an error message saying that the file wasn’t saved. Surprisingly, the file is actually saved despite the message. However, because I get this error, I need to refresh the page just to confirm that my changes were applied.The error in onedrive translated is something like: "There was a problem saving this file. Please try again.":I prefer using the web version because I don’t need to downloa

Estou sem acesso ao email a mais de uma semana, *** Email address is removed for privacy ***

I recorded a macro and added a series to a chart. This is what was recorded. ActiveChart.SeriesCollection.NewSeries ActiveChart.FullSeriesCollection(1).Name = "=""ChCp25g1.X""" ActiveChart.FullSeriesCollection(1).XValues = "==D6_TRK.xlsm!ChCp25g1.X" ActiveChart.FullSeriesCollection(1).Values = "==D6_TRK.xlsm!ChCp25g1.Y" Obviously the extra "=" sign is not correct. (Where you see "==" in the above recorded code). When i corrected it to one = sign, the macro could be played back and modified to put the adding of new Chart Series' in a loop.Can you get this fixed? I think i ran

MS LTSC office 2024 downgarde Office Deployment Tool can be downloaded to version 2016?

I was having some problems with my OneDrive folder on my School's Microsoft 365 account, so I tried logging in and out of it. As I was signing back in, I checked the box for backing up my computer, but I changed my mind shortly after. I simply don't want a backup of my computer on my school account because I want it to only be for school-related things. I went into the settings and unchecked every folder that was listed under "manage backups". However, the backup continued so I went into the settings again but the boxes were still unchecked. Moreover, all the guides I've looked through shows i

Hi,I have encountered an issue when using excel on my mac.I have added up all the $ amounts in a column using the autosum formula and the amount totals 0?I have never had this problem before, would anyone know how to assist?See snips below of the formula and the column

Your billing department took out $179 from my bank account on the 13 April 2025.This was a complete shock to me, as l hadn’t authorised it.I want my money refunded please asap.Sincerely,Deborah Clarke Australia 🇦🇺🦘🐨

It's been a week already. I can't access any files on my onedrive either online, phone's app or Pc app. I still can log in to my onedrive account just fine, i can even find and see my files but just can't access any of them. I tried all troubleshooting methods available including reseting onedrive, unlink onedrive etc. Any suggestion or help please?

I cannot access my Microsoft One Drive files or photos on my iPhone 13 or my iPad (both OS 18.3) when I use the app for IOS. I have no problems accessing the content using the website browser, so I know all the content is there - but none of it is showing on the app. When I click on files in the app it says ""Your files folder is empty" (it's not!). When I click on photos I get a circle going round and round for ever, or sometimes I see a only a very tiny fraction of my photos (really, just a handful out of many thousands). Or sometimes just a blank page. I have logged in and out of the One D

A couple weeks ago my Microsoft 365 account ran out, and then got renewed. When it ran out, OneDrive dropped down to 5GB of space, and was correctly telling me that I was about 90GB over. Once the subscription was renewed (about 1-2 weeks ago now), the PC version still said I only had 5GB of total space. Presently, the PC app is still telling me that, but when I view OneDrive on the web it says the correct 1TB of total space. I've already tried unlinking and relinking my computer, and it hasn't helped in the slightest. Nothing I've seen online has helped thus far so I don't know what do to.