Recent Discussions
Rename Cell to Various Different Sheet Titles
Hi, I am trying to create a formula that allows me to have cells equal to the names of different sheets. I have read several interesting posts that created solutions for having a cell automatically change to the name of whatever its sheet is, however, I am trying to create a table that automatically fills out the rows as I add new tabs. For example: I add a new sheet and name it "March", the next column title in my table will be "March". Having to do it manually at the scale required would be quite difficult. I believe this may require the use of VBA, and my attempts to teach myself were not very fruit-full. Is this possible? Thanks in advance.Solved134Views0likes6CommentsCannot 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. Bryan67Views0likes3CommentsError exporting file as PDF: The online service is not available in your region.
On MacOS 15.5 with the latest (enterprise channel) or Microsoft Office We have a issue currently that certain users in different location is getting a issue when saving as a pdf when the option 'best for electronic distribution and accessibility is selected. "Error exporting file as PDF: The online service is not available in your region. Please contact your administrator." This uses the Microsoft online services when using 'best for printing' - it works fine as thats a local pdf printing and does not use MS online services the region is set to UK we are going to look at the locations and see if any traffic is being blocked as well8Views0likes0CommentsEasier Configuration Promised for the Microsoft Authenticator App
The Microsoft Authenticator app is a secure authentication method for MFA. The app is getting an easier way for backup and recovery, which should make it easier for people to move to new iOS devices. Instead of a Microsoft recovery account, Authenticator will use the iCloud keychain. The update is expected to roll out in September 2025. https://office365itpros.com/2025/07/10/authenticator-app-backup/9Views0likes0CommentsMicrosoft 365 Cloud vs Desktop Applications
I am having issues with the Microsoft 365 Professional version which supposedly should display the documents as a replica on the Cloud when edited using the Desktop version of the same application. Shown below is what a Microsoft Word document looks like side-by-side Cloud vs Desktop: It would seem that spacing and page breaks would hold properly in the Cloud version (shown on the left), but do not. My understanding is that Microsoft Office products have always had an XML base, so technically, what is produced using a Desktop version of an application should display as a replica when opened in a Cloud version of an application. However, what I am seeing is that I lose page numbering and properly spacing in my Cloud version of the same exact document which is pulled from the same exact file location. I am constantly doing double the work to create a perfect document. Are there any suggestions from Microsoft 365 support that might help remedy these formatting issues?122Views0likes1CommentSecurity verification for 365 business account
I've tried everything to get a business account, different browsers, clearing cache, incognito mode, using different phone numbers etc - but it keeps failing at the last step (security verification) when entering my phone. number. It says "Something is wrong with that phone number. Try a different one." No matter what I do, it doesn't go past that. I've tried contacting Microsoft support for 2 weeks - I never get to an agent and then it disconnects me. This is my last attempt. I am based in South Africa, recently bought my business domain and I just want to set up a business account for 1-4 people.48Views0likes1CommentSpan/split columns in MS Word
Hi, I received a PDF that was originally designed in InDesign. The client asked me to convert it to MS Word. The text is set on two columns while Heading 1 and Heading 2 are set on one column. In InDesign is quite simple because there is a paragraph setting that allows me to span a sentence or a paragraph the columns or to split to columns a sentence or a paragraph. For those who are not familiar with InDesign, I will explain: If I set a text to flow on two or more columns but I want the headings to go on one column, I set the paragraph style for heading1 to span the columns. At that point, the InDesign breaks the text so that heading 1 will flow over all columns. On the other hand, if I set the text to flow on a single column, I can choose a bullet or numbered list to go on two columns. I select the paragraph(s) and choose split column by entering the number of columns I want. In MS Word I found no such option. Therefore, I set the MS Word document with infinite section breaks and column breaks. In the beginning, I thought that working with tables instead of sections and columns would be simple. Nevertheless, I decided on this approach as presented in the above screenshot. However, I am wondering if is there an option for doing that much easier and faster. Thank you. Sebastian92Views0likes1CommentEnabling per-group MFA
We're looking, if possible, to enable MFA "per-group" and not "per-users" in the Office365 Organization. IN On-Prem AD we created group GRP-MFA and replicated it to O365 via Entra ID Connect. We used that group to select which Authentication methods are available to Group's members but then we couldn't find a way to enable MFA "per-group" but only per users. The licenses available are Microsoft 365 Business Standard Thanks SC14Views0likes1CommentI need some design help
Hello Excellers, This is what I have: On a Worksheet lets call it Names I have: In Column A 6000 names of people. In Column B for each person I have a skill set codes. P,F,G,I P&I,F&G In Column C I have the time they started their shift In Column D I have the time they ended their shift I need: On a different sheet lets call it Assignments: To make In-Cell Data Validation with Drop Downs in such a way that: If I have a machine that requires Skill P ONLY the people with P or P&I will be in the data validation drop down list. If a machine needs G skill then ONLY the people with G or F&G will be listed in the data validation drop down list If a machine needs skill I only the people with skill I will be in the data validation drop down list Essentially I need to make each data validation drop down list be dependent on the value in the skill column on Sheet Assignments. Now I though of making multiple lists one for all the People who have P skill, one for all the People who have F skill, and one for all the People who have I skill, and so on, and even though the skill sets will change but not often, I thought maintenance will be an issue. Oh and if the person is not working today (there is no start time in Column C) then their name will NOT appear on any list! Also if the person leaves (there is a time in Column D) then the name will stop appearing on any list! Either VBA or worksheet formula solutions will be OK. Any ideas? Thanks in Advance. GiGI53Views0likes1CommentSort in Query not Displaying
I have no clue how to word this. Basically, in a form I have a field called Members. This field is a drop down menu that lists all of the Members for a meeting via check boxes. I can then tick the checkboxes for the people who attended the meeting, click 'ok', and then when when I run the report, their names will appear. I don't need this information saved; just to display on the report so I can print it. Here's my problem. Not all of the members can vote, so I want the members who can vote listed first, and the rest of the members listed next. I've put in my custom sort formula in the Members query. When I open my Members dropdown box, they are listed exactly the way I want. However, as soon as I tick on the names and then click 'ok,' it's displayed in order of the primary key. When I run the report, the names are still sorted by the primary key. I've gone to every query and table I can find to create my custom sort, but it keeps defaulting to sorting by the primary key. It's driving me INSANE. Any idea why it's doing this? I've dug through google and haven't had luck finding an answer that works. Thanks in advance!162Views0likes16CommentsImproving the Processing of Protected Messages in Shared Mailboxes
A sometimes overlooked 2024 update delivers easier access to protected messages delivered to shared mailboxes. Instead of direct assignment of Full Access to user mailboxes, access can be controlled through membership of a mail-enabled security group. It’s a small but very nice change, just like any update that eases the life of tenant administrators. https://office365itpros.com/2025/07/09/shared-mailbox-access/7Views0likes0CommentsCalculate Due Dates, excluding Holidays and Weekends
Hello all! I would like to calculate a due date, excluding holidays and weekends. This is my data: The "COH Due" column is being manually entered, but I want it to be automatic. So, starting from whatever day is in the "Date Accepted" column, I want to add 7 business days to it. I'm not sure what formula I would need for that. Any help would be greatly appreciated. Thank you!Solved113Views0likes7CommentsNon-linear interpolation formula
I have been trying to do this for a while but without success. There is a formula somewhere (using a power law relationship or something) but I have not been able to do it. I basically need to find a corresponding value (column B) based on an input in column A. A B 10 5 20 2.5 If the inputted value (in column A) is 15, then the output in column B would be 3.75. Any way of creating such a formula in Excel? Columns A & B hold a non-linear relationship. Any assistance would be hugely appreciated. Thanks.30Views0likes1CommentCumulate percentage returns.
Hello, I have investment returns which I would like to cumulate. I have positive and negative returns in percentage figures. I am struggling to find the formula, i.e. GEOMEAN doesn't work well with negative returns. I apprecieta every tips and hints! Best wishes, Pascal52Views0likes1CommentHow to correct "#N/A" when using Rank function and Index function
I am trying to create somewhat of a scoreboard that eliminates the lowest ranking player per level. The problem is, sometimes the players have the same score and my formulas end up showing the them as #N/A. I have enclosed an image to better demonstrate my issue. You will see in column E & F, because three players have a 0 score, the two at the bottom show up as #N/A. The same applies to the two players in Level2 that have a score of 10. I have enclosed the formulas I have been using to the right. Is there a way to correct this so that the names and their score, even though they are the same, show up? Or perhaps is there a better way to do this? Thank you so much. Any assistance will be very much appreciated.74Views0likes2CommentsExcel Formulas not Working
The formula (J679) I have in the first image should return a value of 1 if the conditions in B573 and B638 is greater than or = to 1, which should sum the H cells. With nothing in either cell (other than the formulas in the next 2 images), the content in the J679 cell is the sum of the H cells. This can't be correct since there is no 1 being displayed. If I remove the formulas and manually insert 0's or 1's into B573 and B638 the formula in J679 works perfectly. I typed this into AI and it gave me several solutions to try. The format for those cells is General. The font and background colors are different colors (so I would know if there was a 1 in the cell by accident). Any thoughts or suggestions?48Views0likes2CommentsExcel opens copy of file every time i click on the file and when i try to save..
I will start from the beginning to make sure you understand: I right click on the file which is protected Dialog box for password opens, but this dialog box is for the "copy file" If I enter the password for the "copy file" it opens a grey blank excel file (print screen below) After this I close the "copy" grey excel file Dialog box for the original file opens I enter the password and is all good... If I don't enter the password for the copy file, then every time I push "save" I get this dialog box for the copy fie to introduce the password.4.6KViews0likes6Comments
Events
Recent Blogs
- This update will make finding and using external data sources faster, smarter, and more intuitive.Jul 08, 2025522Views1like0Comments
- When you transfer a call, the transferee can see a Microsoft 365 Copilot summary of your discussion before they joined.Jul 07, 2025802Views0likes0Comments