Recent Discussions
Looking for help with a single Dynamic Formula Ranking Points by player and dropping lowest score
Name Finishes Andrew 1,1,2,3,7,8 Randy 2,4,5,5,8,9 Chris 1,1,2,3,7,8 Bill 1,4,6,6,7,9 Jeff 2,3,5,7,8,8 Reed 4,4,6,7,7,9 Doc 3,5,5,6,7,9 Steve 1,3,5,6,8,9 Paul 2,2,3,3,4,9 Points (1st, 2nd, etc) 165 105 75 50 35 25 20 15 10 Expected answer with lowest point dropped Name Points Chris 530 Andrew 510 Paul 410 Steve 315 Bill 285 Jeff 250 Randy 240 Doc 190 Reed 165
Copy and Paste Will Not Using the Destination Formatting
I am writing a book in Wood and will submit it to Amazon KDP, and I have set up the document per KDP guidelines. I am working on an English version and a Spanish version at the same time as two separate documents. The text is justified. Both documents have Normal/Modify settings set up exactly the same. The Fonts and Paragraph settings are exactly the same. I have gone into the Options/Advanced area of Word and played with all of the Cut, Copy, and Paste settings to try to fix my problem. But I can't figure out what is going on. I created the Spanish document by using Google Translate to take English paragraphs, translate them, and pasted them into the Spanish document The Spanish document is completed, and all of the formatting looks fine. So I already have paragraphs that are a certain size in the document, meaning they take up a certain number of lines. I am now editing the book using the English document. Something has changed with the Spanish document! If I make a small edit in an English paragraph, use Google Translate to deal with the edit and do a new translation, and then copy and paste that edited Spanish paragraph from Google Translate back into the same place as the original paragraph in the Spanish document, the words are slightly more compressed together, so the paragraph gets shorter! This happens if I even change just a single word in a paragraph, which has not really changed the length of the translation. The paragraph will become shorte by a half of a line, or a full line on long paragraphs. This is all becasue the words are being spaced slightly closer toegether now, versus when I originally crated the document. Also, when I start to do the paste, from Paste Option only get the option for "Keep Text Only." I don't get the multi-paste option box. Something has changed in my setup of Word from the time I created the original Spanish document, and what is happening now. I can't figure out why the formatting of the destination, or using merge formatting, is not working! It's making up it's own jutification spacing all of a sudden. I can't figure out why now a cut and pasted paragraph from Google Translate is making the spread between the words just slightly tighter. The latest thing I tried was Review/Language and choosing Spanish for the Spanish document, and that did not work. Any ideas? Gordon
MS Word is throwing up 'Error 4608' I haven't a clue what to do.
Hello, I wonder if anyone can help me here, because I am at a TOTAL los... I have a Word document that I have been updating for a few years, which is a sort of log. It has worked well up until today. Now, whenever I try to save the updated document, a very old fashioned (looks like Windows 3.1!), error message window appears which is headed 'Visual Basic for Applications' and in the window it says: Run-time error: '4608': Undefined dialogue record field There are then four buttons at the bottom labelled Help, Continue (which is greyed out), End and Debug. I have no idea what this error message means. Clicking on End gets rid of the error message, but prevents me from saving my updated document, and the next time I try to save it the error message just reappears. Clicking on Help takes me to a website with the title 'No F1 help match was found', followed by a load of technical computer-geek stuff I don't understand. Clicking on Debug seems to open a new window, but I do not know what it is... Here is a screen-shot of it: The highlighted text seems to refer to Bookmarks, which is throws me because I only associate Bookmarks with my web browser, not MS Word. I'm sure I haven't added any bookmarks to my document in any case. Can anyone enlighten me as to what is going on here please? Thanks
line spacing
I'm creating a word doc (w/the help of ChatGPT). I copied and pasted from GPT into a Word doc, but I can't duplicate the spacing from one line to another. When I put the cursor behind a line and hit enter, the next line doesn't match up. Industries We Serve ✔ Medical & Clinical Laboratories ✔ Pharmaceutical & Biotech Facilities ✔ Research Laboratories ✔ Dialysis Centers ✔ Electronics Manufacturing ✔ Industrial Processing Facilities This is what happens when I put the cursor behind Laboratories. The spacing is way bigger and has no checkmark. What gives? ✔ Medical & Clinical Laboratories ✔ Pharmaceutical & Biotech Facilities ✔ Research Laboratories ✔ Dialysis Centers ✔ Electronics Manufacturing ✔ Industrial Processing Facilities
How do I get repeating part numbers (data) to auto fill data.
Sorry I am not very Excel savy but I was tasked with filling a spreadsheet with data of our part numbers, their description, the supplier we get them from, our assigned supplier numbers, and our suppliers part number for kits we make in our company, there are over 9000 but I have noticed that there are a lot of repeating part numbers so I was hoping there was a way so that I could have that data auto fill. I can post a link to the document it does not have any proprietary data that I can see. https://gpcompinc-my.sharepoint.com/:x:/g/personal/zachv_gpcompanies_com/IQAYSdPfHYQvRp6TRW4hg_xjAYh_4Jjl2Z_aCXX_64zMf50?e=MKDtrRAllow removal of "Copilot Suggestions" from right-click menu
I have been using Excel for decades and CONSTANTLY use the right-click menu for quick access to basic functions (e.g., "Insert"). Ever since "Copilot Suggestions" was added to the drop-down list, it always throws me off due to its placement. I have Microsoft 365 on Windows 11 Pro. I have searched for ways to remove this from appearing there and the result said "go to File > Options > Copilot and uncheck the 'Enable Copilot' box". However, when I attempt to do that, there is NO "Copilot" option available! PLEASE allow removal of "Copilot Suggestions" from the right-click menu OR at least the option to move it to the bottom (so it isn't in the way of things used ALL the time). I realize that Copilot is a great resource for many users, but I am confident in my Excel skills and in my ability to research/learn new skills the "old school" way, so I have little use for this feature now and would prefer to hide it.equation or function?
+0.3°c -0.1°c +0.4°c Looking for either an equation or function for this, in order to simply enter column A & B and have answer autofill. The number in column A is the constant number that I want column B to be ie: what must happen to column B to equal column A, as you can see in column C you add 0.4 so that column B equals +0.3. As seen below there is variation from positive and negative numbers in both columns therefore at any given time it will be adding or subtracting?? +0.2°c -0.2°c +0.4°c +0.3°c -0.3°c +0.6°c 0.0°c -0.1°c +0.1°c -0.1°c +0.3°c -0.4°c -0.2°c 0.0°c -0.2°c -0.1°c +0.2°c -0.3°c anyone help me out, could save some considerable productivity time?Want to add a minus number, alongside the existing formula
Hi all, I have here a handicap calculator that's primarily used for tenpin bowling and I would like to add an enable / disable (with Yes or No) a Minus Handicap along with the existing formula for each cell (in columns B, E, H & K), plus the option to adjust the percentage to affect only the minus numbers. Hope it all makes sense. Thanks in advance.VBA events stop working for one user when another user opens the shared workbook
Hi, I’m experiencing a strange issue with VBA in Excel. We use several Excel files as a CRM system, all with VBA (mainly worksheet events). The files are shared so that my employee and I can work on them. Recently, VBA events stopped working only on my computer in some of the files. Important observations: For my employee, everything works normally. Manual macros run correctly on my machine. Worksheet events (like Worksheet_Change) do not fire. Application.EnableEvents returns True. Macro security and Trusted Locations are already configured. The files are almost identical (same structure and VBA code). What makes it even stranger: A file that worked for me yesterday stopped working today immediately after my employee opened it. Since then, the VBA events no longer trigger on my computer in that file, while they still work perfectly for him. So it seems that when another user opens the shared workbook, VBA events stop working only on my machine. Has anyone seen something like this before? Thanks.Filter Function or TAKE-DROP Function
Dear Experts, I have a Data like this:- Column A -> Has the File Names, and Column B,C,D have their corresponding data, In Column F I have the unique File Names and from G/H/I -> I need the start of the hfn/sfn/slot and in J/K/L the end of the hfn/sfn/slot for that File Name as populated , How to achieve this? Thanks & Regards Anupam ShrivastavaLimited to 200 submissions
The helpdesk has confirmed that I have an m365 family subscription. This would allow me to receive 1000 responses in Forms. However, when I log in to Forms with my details, only 200 answers are accepted. In addition, I get a "buy button" on the screen. In other words, Forms "thinks" that I have a free plan. Who can solve this for me?SharePoint Online Drops One Time Passcodes for External Access
From July 2026. SharePoint Online and OneDrive for Business will use Entra B2B Collaboration (guest accounts) to control external access to shared files. This change has been coming since 2021, but it takes time for organizations to get their heads around changing the way to grant external access. It’s time to embrace guest accounts, and that means doing some work to manage guest accounts on an ongoing basis. https://office365itpros.com/2026/03/06/guest-accounts-spo/Freezing multiple rows
I just need to freeze the top 3 rows in a spreadsheet. Easy: select the 4th row, click 'Freeze Panes' and choose the 'Freeze rows' option. Except that the option isn't there - the only option offered is to freeze the top row. I am using Office 365, so my Excel is a current version. And I am working in Normal View. So I don't understand why I cannot freeze multiple rows any more!
Events
Learn more about the capabilities of Agent 365 in this live 'Ask Microsoft Anything' with product and engineering team experts! Get your questions answered about capabilities for agent observability,...
Online
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- Microsoft Most Valuable Professionals (MVPs) are the heartbeat of the Microsoft ecosystem—and at Microsoft 365 Community Conference 2026, your impact takes center stage. Imagine connecting face-to-...Mar 06, 2026
- Edit images directly in PowerPoint to enhance, refine, and perfect visuals without leaving your deck.Mar 06, 2026
