Recent Discussions
Accept & Do Not Send a Response
Hi Calendar Community, We'd like your feedback & reactions to a change we're considering: Current experience: When attendees receive a meeting invite, they are provided with 3 response options: The first two options (Edit the response before sending & Send the response now) both send an email to the organizer, and the attendee's response is recorded in the organizer's tracking list. The third option (Do not send a response) does not notify organizer, so the attendee's response remains as "None" in the organizer's tracking list. What we'd like to change: Many users report that they expect Do not send a response to be recorded in the organizer's tracking list, but just not to send an email. We are considering updating the behavior so that all 3 response options are recorded in the organizer's tracking list. Attendees can still use the Do not send a response option to avoid sending email to the organizer, but their response would now be recorded & shared with organizer. Questions to the Community: Do you like this change? Does this match what you & others are expecting? What about when an organizer does not request responses (so there is just a simple Accept button without additional options)? Do you think the intention is to avoid email responses? In other words, would you expect this same behavior (responses are always recorded) to apply even when organizer does not request responses?Solved211KViews96likes307Commentssum by color when colors are set by conditional formatting
i have a column of numbers that are color coded (to represent a specific mfg department) and I need to total the values by color. Meaning I need to total all the values that have the same background color. I have done an exhaustive search online and was able to quickly find a way to sum by color, unfortunately it only worked for cells whose color was set manually (NOT using conditional formatting). I have found a few references to VB code that should provide the functionality but I can't get any of them to run (except for the one that works for manually set colors). I have control of the data that I'm trying to sum. is there another method to "tag" values? I thought of adding a letter prefix, but coulnd't find any way to sum a column of numbers that are contained in text strings. Any help would be greatly appreciated!! I'm using Office 365 (excel 2016) on a windows 10 machineSolved256KViews0likes304CommentsThe new Outlook search in the title bar is disconnected from the content it searches
I appreciate the benefits of Microsoft Search in the Office apps but I'm getting feedback form multiple people that having the search in the title bar is unhelpful because they need to use the title bar for dragging the window around. In Outlook in particular, having the search box so far away from the content that you're searching is jarring. I understand the value of consistency, but I think that the utility of putting search with the content it searches overrides being consistent at all costs. Can we have an option to move the search box back down to the content in Outlook, and perhaps not to have it in title bars at all?654KViews139likes222CommentsCan I remove Modern Comments and revert back?
My Word (on Microsoft 365) has updated to Modern Comments. I have a number of problems with the useability of these comments, based on the way I have used them in the past (for context, I am an educator and primarily use them when marking student assignments). The main issue is that autotext is no longer supported in a comment. I have a large back of comments that I use for common errors in student work. Some of these comments are up to a paragraph, or contain URLs to instructions for certain things. It's incredibly helpful to be able to insert these quickly and will increase my marking time substantially if I can't use them. Comments are slow to open. If I open a comment using a keyboard shortcut (on a Windows computer) and start typing, the first one or two letters often gets inserted into the main text They don't use the same autocorrect tools as the main text. My typing has evolved to use those features. Two capital letters at the start of a comment don't get corrected, and simple typos don't get corrected There are more steps to use them than before. I don't share my documents, so being able to edit comments and post when they're finalised is not particularly useful for me, as no one else is looking at them until I send the document. However, I can't click out of it to finish, I have to click or ctrl+Enter to post. I also can't just click INTO it to edit, I have to click on more buttons. It doesn't make sense to only be allowed to edit one comment at a time, particularly if the idea is to not post them until you're ready to share with others. Sometimes in the course of writing one comment, I want to comment on something else first and then come back to the previous comment. You're forced to finish one first, to the standard you're happy for others to see, defeating the purpose of not having to post until it's finished. Why not allow multiple to be in draft? If I forget to post and try to type a new comment, it pulls me back to my previous comment and starts typing, making me lose my spot where I wanted the next comment It has added an extra space to the side of the document, which wouldn't be an issue except that making any formatting changes under tracked change, which I often also do when marking assignments, goes into the ORIGINAL pane where comments use to be, widening the document even further (extra space for formatting, then another extra space for comments). My computer screen isn't large enough to cope with the extra width. Once I post a comment, it's still selected. There have been a number of times I've posted a comment then tried to ctrl+F something in the document, but it won't respond to my ctrl+F. Not something that is necessarily a huge issue but it is annoying and I can't see the purpose for keeping a comment selected when it's posted and non-responsive. Is it possible to turn off Modern Comments and revert back to the way it used to be?Solved157KViews58likes220Commentsmacro VBA excel nommer une cellule
Dans une macro, je veux donner un nom à une cellule donnée, à savoir celle où je suis au lancement de la macro. si je laisse "range", avec des références absolues, la macro fonctionne, mais une seule fois. Le nom choisi disparait de la liste de la feuille, mais est toujours présent dans les noms de "formule-gestionnaire de noms". voici ce que j'ai écrit, qui ne fonctionne pas: ActiveWorkbook.Names.Add Name:="horo4", RefersToR1C1:=ActiveCell.Address Merci de m'aider!Solved28KViews0likes204CommentsStock Data Types Wont Refresh - Provides Erroneous Error Message
I have an Excel workbook I created a few months ago and this afternoon while I was away, the "stocks" data type refresh feature stopped refreshing. The error message I receive instructs me to sign in to an account associated with this product (Excel), but I am clearly signed in. To be sure, I sign out and sign back in. Hit 'refresh' and receive the same error message. MS tech support tried to make a manual repair during a chat session, but it still will not refresh. Any thoughts? Thanks in advance.31KViews18likes195CommentsSending email as alias in office365?
I used to have my domain email hosted in office 365. The reason i switched was because of a lack of a feature i really needed. You had the ability to create multiple aliases in office 365 so you could receive multiple emails for your domain in your inbox. For example say my domain was example.org. I could recieve emails from bob@example.org <--primary email address orders@example.org newsletters@example.org. the only big thing missing was that you could not "send" from any email other than the primary email. so in the example above i could not send email as orders@example.org or newsletters@example.org. I could only send email as bob@example.org. Is this still true or can you send email from aliases? I don't want it to look like it came from the primary email "orders@example.org in care of bob@example.org". The email i send with an alias should really look like it came from the alias. This is the only reason i'm on GApps and i'm hope to swtich back. Is this feature still missing? thanks472KViews4likes189CommentsAccess doesn't close properly. A remaining background process can only be terminated in task manager
Since yesterday I noticed that in all my Access databases there is a problem when I close them. When I close a database, it leaves a background process that can only be terminated in Task Manager. Without this, it is not possible to (re)open databases! I have already checked some possible causes. It also concerns databases that I have not changed at all in recent months and that worked fine until this week. Therefore, I have to assume that it is a bug in an automatic update! It seems that it has to do with a malfunction in the deallocation of allocated memory in VBA source code. Did anyone experience the same problem? Are there already fixes or solutions available?Solved90KViews8likes189CommentsHow to count and sum "Condtional formatting" cells by color in Excel 2010?
I installed few add-ins for counting "Conditional formatted" cells but all are generating an instant (one-time) numeric result by activating that command. Also, I tried a code which gives an instant counting of 1 picked color without a total sum of all other colors -in my case 12 colors in a matrix. ("How to use the code to count colored cells and sum their values" - https://www.ablebits.com/office-addins-blog/2013/12/12/count-sum-by-color-excel/ ) My question is: Is there any functional code (or other aproach) which can count and sum all cells by "Conditional formatted" colors, on one sheet, and that the generated result is linked through common formulas? That can be updated/refreshed/code run during the work process as a complete overview of colors of a matrix (and not by picking every color every time as I mentioned). Thanks in advance!Solved282KViews1like181CommentsBack-up tools for Office 365
Started this question a while back on Yammer. What tools do you use to back-up mail and files stored in Office 365? The fact that your files are back-upped inside and outside the datacenters of Microsoft only protects you against hardware and software failures on Microsofts side. It will not protect you against accidentally deleted files and mails, which is discovered after 30+ days or after the site trashbins have been emptied. At least that's what I think. Anyone has an answer? My customers are typically small companies, under 10 users. Sometimes even just 1 to 3. I use de SkyKick Back-up tools in my own O365 tenant. Which was an offer in the Microsoft Partner Mail recently.226KViews6likes179CommentsRemote assistance with Quick Assist is changing
Hi Insiders! Russell Mosier and Bianca Taylor, from the Experiences + Devices team are excited to share an upcoming change to their remote assistance app, Quick Assist. Remote assistance with Quick Assist Quick Assist is an app in Windows 10 and Windows 11 that enables you to receive or provide assistance with your PC over a remote connection. The current built-in Quick Assist app is reaching end of service. To keep your remote assistance sessions secure, you will need to download the new Quick Assist from the Microsoft Store. How it works Select Start > Microsoft Store. In the Microsoft Store window, type Quick Assist in the Search box. Click Quick Assist in the list, and then click the Get button. Find out the rest here in the blog post! Cheers, Nathan Office Insider Community Manager Become an Office Insider and gaining exclusive access to new features and help shape the future of Office. Join Now: Windows | Mac | iOS | Android112KViews4likes143CommentsConditional formatting for entire row based on data in one cell
I need all cells in a row to highlight a certain color if the data in one cell contains a specific word. What I specifically want is for an entire row to turn grey if the status cell contains the word "SHIPPED." I know how to make that specific cell highlight the color I want, but not the entire row of the sheet. Thank you for your help!Solved3.5MViews8likes132CommentsHow can I escalate issues in Office 365?
I have had a support case running with 365 for a couple of weeks. They close the ticket over the New Zealand weekend because of time differences, I reopen it and then have to provide the same information again. My question is, how can I escalate poor service? Cheers Mark51KViews2likes131CommentsSomething went wrong - Forms - Permissions?
Hi All, Sent out an office 365 form as normal but none of our users can access it, getting an error message saying ‘something went wrong’ and that they don’t have permission to access the form, despite being logged in with their 365 credentials and attempting to access from an AAD Joined device. I see this has been a previous issue but I’ve never had a problem till now. Is this a known current issue as there’s no advisory or service interruption notice on the admin portal health section for this? A speedy response and solution would be amazing! Cheers, NicholasSolved100KViews0likes129CommentsOutlook (365) Need Password - Issue
Hi, We are using E3, outlook 365 in our company. Some of our users' outlook stop sync with exchange and ask for password, as shown in below image: to fix the issue, I clear entries in Credential Manager, Delete Temporary Files, unchecked "Use Cached Exchange mode", restart system and check this again. but after some couple of days, outlook again stop sync and ask for password. I'll appreciate for any possible support to fix this issue permanently. Thanks,Solved1MViews1like129CommentsRemove On Premises exchange Hybrid and go fully Online
Hello, I currently have a scenario where there is a Hybrid Exchange environment with 1 server. All my mailboxes have been migrated online. I would like to completely remove dependency on local AD and I do not care about AD synchronization. How do I "tell" the O365 tenant not function on it's own so that I can manage 100% from 365 Administration? I do understand that my MX and other DNS records will need to be changed. Are there any solid guides out there on decommissioning the on premise exchange server. I want to do this with the least impact on users. Thanks, Keith162KViews0likes124CommentsOffice 365 "The fine print" popup message - is it legitimate?
Greetings, I have been happily using Office 365 (mostly Word) for many years, and I have never had any problems with any of the products. This morning when I loaded Word I was confronted by a pop-up message called "The fine print" asking me to accept terms of use in order to continue. I have been using Word for several years on this computer and I have never seen anything like this, I just want to confirm that this pop-up message is in fact legitimate and not some form of spyware or adware impersonating Microsoft. Any assistance would be greatly appreciated, Glenn Here is a screenshot of the pop-up:Solved48KViews0likes122CommentsPopulating cells with a Date across 12 TABS
Hello Community, If you are up to a challenge and if it possible to accomplish with formulas or VBA I've got a challenge for you. I have 12 sheets in a workbook that look exactly the same. Each worksheet represents a month. So Jan, Feb, Mar and so on up thru Dec. Each sheet consists of 317 ROWS. Each ROW represents an individual building number. ie, 200, 210, 215, 218 and so on. Each month I have to physically go to 26 or 27 buildings and physically read the utility meters, Water, Gas & Electric and jot down the readings. I then enter these numbers (Readings) into the workbook and on the sheet for the month which the readings were obtained for. The task here is to obtain 100% of the meter reads over the course of 12 months by dividing the number of buildings by 12 to determine the number of reads necessary per month to obtain 100% by the end of the year. So, what I am trying to accomplish is the ability to enter a date against a building number, for example JAN, and have that date populate all the other cells for that building number across the months of FEB, MAR, APR and so on right on up into DEC. In essence showing that the meters for this building have already been read and thus locking those cells from having any additional entries being made into them. The only way to change the date would be to go back into the month the meters were originally read. Any change, if it were necessary would reflect/update all those other cells. Now lets say dates were entered into the FEB worksheet for which no dates were entered in the JAN Worksheet, the same thing would happen but the date entered in FEB would also reflect into JAN as well as MAR, APR, MAY and so on right on up into DEC. This process would continue all the way up into DEC. If a date was entered into DEC for a building that did not reflect as having its meters read, the DEC date would reflect all the way back into the JAN worksheet and populate all cells for that building number up thru Nov as DEC is the originating date entry. The idea here is to be in a current month and be able to look at the current month worksheet and be able to determine what buildings still need to have its meters read. So come DEC for instance, you should only see what buildings still remain to have its meters read. Again, the idea is to read a number of meters each month that would as evenly possible to obtain 100% reads by the end of the year. More or Less could be read each month but this method will always show which ones still need to be read. So what do you think about this challenge??? This will probably keep you on your toes. Keep in mind, I have 12 worksheets, each having its own TAB within a workbook. And on each TAB I have a cell, within a column, for entering a date for Electric Read, one for Gas Read and one for Water Read. Anyone up to the challenge? More details can and will be provided upon request.Solved24KViews0likes121CommentsForm now wont open showing Sorry, Something went wrong
Working on a new form and now the form won't open and displays this.Solved58KViews0likes117Comments
Events
Recent Blogs
- We are excited to announce that the highly anticipated keynote sessions from Jeff Teper, Vasu Jakkal, Jared Spataro, and Brenna Robinson are now available for all to experience. Visit our conference ...May 22, 202574Views0likes0Comments
- 2 MIN READWe've eliminated the unused space between the ribbon and your canvas, giving you more room for what matters most.May 08, 20251.1KViews1like5Comments