Recent Discussions
COUNTIF Formula
I have an assignment where I have a sheet of student test scores. My sheet contains the students in my class and if they got the answer right or wrong on a 20 question test. I have already averaged out their percentage on the test. I am to find the percentage of 90's, 80's, 70's, 60's and 50's. When I put the formula in and the rows of data that I want evaluated, I get an error message that says "you have entered too few arguments for this function. Here is what my formula looks like: =COUNTIF(V2:V19), ">.895" Can anyone tell me what I am doing wrong?60Views0likes3Comments- 33Views0likes1Comment
Non profit business standard users join PCs to Active directory
Hi I have waded through masses of online stuff and can't get a clear answer to this. It is driving me insane! We have about 10 users on nonprofit business standard - all running win 10 or win 11 pro. I need to allow different users to share a PC - but have user restricted access to microsoft 365 online data - sharepoint - web apps etc Most older machines are domain aware as in you login with the domain account - they work fine. Newer machines cannot and all have only local accounts but have stored credentials for the main user for sharepoint etc. That is a problem when a PC is shared as someone may have logged in locally but they have left credentials for sharepoint allowing access. to privileged info If I upgrade one of the licenses to business premium would that enable me (with admin privs) to join existing and yet to be bought PCs to the domain or would I need a premium license for each user? We don;t need the higher up functionality such as intune as far as I know - just the ability for fred_AT_ourcharity.com to share a PC sensibly with bill_AT_ourcharity.com34Views0likes1CommentDoes Microsoft have an employee directory?
Hi everyone, Quick question for the group. My company uses Microsoft Teams every day, and people are constantly trying to find the right person internally, who owns what, who reports to who, who sits in which team/department, etc. Teams search and profile cards help a bit, but we’re really looking for a proper employee directory, specifically: A clean employee directory experience (not scattered across different places). Rich employee profiles (photo, title, department, manager, contact info, location, etc.). Strong employee search (by name, department, role, location, ideally more) Is there a native employee directory in Microsoft 365 that does this well out of the box. If not, what are people using instead, SharePoint, Viva, custom build, or a third-party directory that pulls from Entra ID / M365? Would love to hear what’s working in real life.Solved298Views1like2CommentsWord freezes or crashes when pressing the G key in the file search
When pressing the letter G in the file search on Word, it either just freezes and doesn't respond or crashes immediately. Regardless of whether Word is in Safe Mode or not. It also pops up a "Word couldn't start last time" pop-up when I try to open the app again and asks if I want to open it in Safe Mode. Which, as I said, still has the same problem. As far as I can tell, that's the only issue with Word. Everything else works great so far. This does not happen with other apps like PowerPoint or Excel. I have only recently reinstalled all the apps and it does not seem to have helped. Windows 11 25H289Views0likes7CommentsCopy contents of one sheet into email
I am trying to copy contents of 1 sheet into an email for distribution. I'm having difficulty just sending th information of just the one sheet. When I attempt to copy, the recipients are able to view the rest of the sheets in the workbook. What am I doing wrong?55Views0likes3CommentsCalculating and adding time
I am trying to figure out how to automatically calculate time differences for a delayed racing start time. I have: a rating which provides a handicap correction factor: PHRF Tod A Sec/ Mile correction number A Total correction in Seconds (based on a distance) This I figured out. I have a set start time for the first entry at 11:00:00 I need to figure out the Start time for the delayed boats as shown in the diagram, but I don't know what formulas will do this. This diagram is taken from a pdf document.Solved147Views0likes5CommentsCannot turn off Copilot in MS Word for Windows as "Enable Copilot" is missing...
This is ridiculous. I have spent over 2 hours trying to turn off Copilot in MS Word O365 version. I am running MS Word in I I Windows 11 (updated) and running what I believe is the most current version. I have been able to go into Excel => Options and uncheck the "Enable Copilot". I do not see such a box in Powerpoint (thank God - I don't see it in the app at all) and have been able to turn it off on my Mac Office Apps. I have an O365 account. When I open Word in Windows and then select the Options I get what is displayed below. Do not see the enable coPilot option, but CoPilot is on. This is ridiculous. I have cleaned the registry and I have seen hacks on how to turn off coPilot by butchering the registry, which I refuse to do. I even removed the coPolite App. MS, I DO NOT WANT TO USE AI TO WRITE. How do I get rid of this? I am EXTREMELY frustrated with this. Bryan2.4KViews1like5CommentsExcel text box overlay- what is it, how to remove?
I have this box that has somehow been inserted into my table. There are underlying cells and I can actually scroll right under this box and also access the cell underneath it. And I can type about 140 characters into this box. Deleting surrounding rows or columns does not affect the box, so it doesn't appear to be correlated to a specific cell. There is no context sensitive help when in the box and almost all normal excel functions are greyed out when I'm in it. Any help is appreciated.171KViews1like11CommentsCan't access Microsoft Authenticator for business accounts
Hello. I am the tech support for a small church, where I am the admin for our MS 365 accounts, which are set up as "business accounts". I have been using Microsoft Authenticator for MFA for years. Recently I switched to a new phone and installed Microsoft Authenticator. All of my personal Authenticator accounts transferred over just fine, but all of the church's business accounts say "Scan the QR Code provided by your organization to finish recovering this account". The thing is, I am the "organization" and I don't know how to generate any QR code to recover the accounts. It was suggested that I could do something about this by logging into my Microsoft 365 administrator account, but when I try to log into my admin account, the only MFA option is "enter the code from Microsoft Authenticator". It's not offering a text or alternate email, only Microsoft Authenticator, which is what I'm locked out of. So I'm stuck in a loop. I opened a ticket with Microsoft Support nine days ago. I have received one phone call since then. The support person insisted that they needed to talk to the account's "alternate administrator", which I set up as my pastor, who is pretty computer savvy but not a deep IT person. They tried to call him one time, but he was not available to answer right then. There has been no communication since then. I'm hoping someone in this group can help me figure this out.172Views1like2CommentsODBC error (incorrect syntax) since 2604
Overnight i have the problem that many inserts in my MS Access app do not work anymore. I get the error Run-time error '3155': ODBC--insert on a linked table 'tablename' failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='.(#102) I have been able to isolate this issue on a column of type NVARCHAR(MAX). If I insert any value except null in this column the error above will show on save. I tested with other variants of NVARCHAR. The problem happens starting from NVARCHAR(256), thus what is Long Text for Ms Access. When i insert the record first with a value null for this column, no error is generated and the record is saved. If i 'Update' the record later with a text value in this column, that is no problem. So, the ODBC connection generates a sql insert statement that is mallformed in case of a long text. I have this problem consistent on all apps and all tables where i have NVARCHAR(>255). My solution is to go back to office release 2508 (semi annual support).Solved404Views1like2CommentsPower Automate not pulling all form answers
I have a flow that triggers fine using the "When a new response is submitted" but the "Get response details" is only returning a few of the answers submitted. I can see the full submission the the back end of forms but Power Automate is not pulling a lot of the submitted answers. It has worked fine for 50 times, the automation is long and complex so if possible id like to stay away from deleting and restoring the trigger and get response details...3Views0likes0CommentsSTOCKHISTORY and Stock Data not working
Is it only me? Or everyone else having the same problem? My Excel 365 cannot use STOCKHISTORY Function anymore. It shows #connect! Error. Also, I cannot use the stock data anymore. (The other data types are not functioning as well.) (The error message says "Sorry, we are having a temporary server error. We are trying to fix this problem.") Is it only me? Or everyone else is having this problem?Solved1.5KViews14likes34CommentsSQL Query editing UI issue
Hi everyone. For a couple of weeks now, my Access hasn't let me edit queries within the SQL option. Version: Access 2604 (Build 19929.20090) Basically, when I access the SQL View, I see the SQL code but can't select it or move the cursor to easily edit the text. It's difficult to explain, but I hope the following video helps: https://drive.google.com/file/d/1knAAwVS48m8WsarmhLeOVFWOdFuCqaUz/view?usp=sharing I've already tried restoring and resetting the installation, but to no avail. I hope you can help. Bets Regards, Emiliano37Views0likes4CommentsMacOS platform SSO deployment issues
Hello, We tried to deploy MacOS platform SSO but the devices are having problems with their authentication. The devices are connected through company portal but keep asking for logins and authentication, especially on reboot. Some users are prompted to sign-in to their entra account several times per hour. To Deploy it we used the configuration setting template: Authentication > Extensible Single Sign On (SSO) Settings: Extension Identifier: com.microsoft.CompanyPortalMac.ssoextension Authentication Method: Password Token To User Mapping: Account Name: preferred_username Full Name: name Use Shared Device Keys: Disabled Team Identifier: UBXXXXXX Type: Redirect Has anyone here experienced similar issues or found a fix for these constant re-authentication prompts? Thanks!33Views0likes1CommentDifferences in Word for Mac and Word for Windows
I've been using Word on Windows for many years but recently have purchased a Mac mini and am trying to get used to Word for Mac. So far I've noticed one super annoying feature of Word for Mac: the spaces, tabs, paragraph symbols, etc., show up in blue instead of in the same color as the text. This is going to create a real problem when I start working on documents where I'm tracking changes, since the paragraph symbols might look like they've been inserted during an edit if the edits are being shown in blue--something I have no control over since other people will have already worked on the document before I get it. As far as I can tell, there's no way to change this. So I staretd wondering : How many other things are this vastly different on Word for Mac? Are there still keyboard equivalents of all the usual functions (like toggling Tracking on and off, adding a comment, saving, etc.)? Are there any functions completely missing from Word for Mac that are on Word for Windows? I still have time to return the Mac I got and try to find a Windows pc that meets other requirements I have. Thanks for any info you might have. I've done a lot of searching on the internet for this and have found very little detailed info.118Views0likes4CommentsFunctionality to mark a slide complete
I do not believe this functionality alread exists but I'm quite sure I'm not the only one that would love to have it added. Now when working in a larger powerpoint slide deck I start with adding a "traffic light" to my slides that's red, and when the slide is finished I turn it green. Then, before presenting I have to delete all traffic lights before the deck is truly ready. This way I can keep track of which slides still need attention and prevent myself from spending time on slides I shouldn't. Now I believe it would be very nice if it was a built in feature where you can mark individual slides as "complete / final" or "needs attention" with visual feedback of this status in for example the navigation pane. How do others handle this and is there a trick I do not know of?42Views0likes2Comments
Events
Recent Blogs
- From full-site to file-level, Microsoft 365 Backup now supports granular browse and restore for OneDrive and SharePoint.Apr 29, 202689Views0likes0Comments
- Discover Clipchamp features that help you fully unlock the power of video and ensure your content lands effectively with your audience.Apr 29, 2026118Views0likes0Comments