Recent Discussions
Page numbering woes
I am working on a lengthy word document. I just used the "insert page number" function in an attempt to number the pages (more than 400). Only page 1 showed a page number (i.e., 1). Any suggestions as to what might be wrong and how I can solve this problem and have all pages numbered? Thanks, in advance.
Word having trouble with 'Find in document'
I am currently editing a long document (around 70K words). Using the search function in MS Word to get to the section I need to edit is hugely valuable. Yet lately, Word fails around 50% of the time to 'Find' the word or phrase I enter in the search window, even though I know 100% it is there. Any ideas how to make this work better?
Microsoft forms and external upload files possible?
Good afternoon, We as a company want to create forms that our customers can fill in with the data we need. Like plans and technical drawings. I hoped that it would be possible to create these forms, but when i try to add the upload file question I need to change the settings to only internal. Is there no possibility to create forms that have the request of uploading files from external parties we send the link to? Kind regards, CarinaSum from cell across multiple sheet, depending on hire date
I can not figure this out, I am trying to make a summary sheet that will count the vacation days across multiple sheets from "Start" to "All" (these are timesheets between those named sheets) for employees. But I need the count to reset on their hire anniversary month and day. Employee 1 - Hired on 1/2/2001 (found in cell B5 on the sheet named "Summary") Employee 2 - Hired on 4/9/2020 (found in cell B6 on sheet named "Summary") In this example, any vacation days in cell F5 (employee 1) across multiple sheets between sheets named "Start" to "All" will count until the anniversary month and day arrives, then it will reset and start counting forward again until that date arrives again. Any help will be much appreciated!Microsoft 365 Apps Admin Center - Inventory Error
We're running into issues trying to access Inventory in the 365 Apps Admin Center (https://config.office.com/). When trying to swap a specific group of devices to a different update channel (Current to Monthly Enterprise), we go into the Apps Admin Center, select inventory and receive a generic error: There was a problem showing the security update status information. Please refresh the page or try again later. 00000000-0000-0000-0000-000000000000 This has been happening for 3 days now. Was working fine prior to that (and were able to flip a few devices earlier in the week). Anyone else experiencing the same/similar issues? Multiple 365 Admin's within our organization are getting the same error, so it's not isolated to 1 person/1 account.Lookup seat number on table plan
Hello all, hope you can help me. In Excel, I've a table plan where I've assigned names to numbered seats. I now want to read the 'read' that table plan and create a list that tells me the name and seat number. I already have the list of names (in Column L), but need a formula for Column M to do the lookup of the seat number on the table plan. The seat number is always located in the cell above the name. For cell M2, the formula should return that Arthur is in seat C7, and in M3, that Ben is in seat B3, and so on. I suspect the formula could be a combination of one of the Lookup variations, INDEX or MATCH, or even using the CELL command, but I've not fathomed it yet. Does anyone have any suggestions on how I could do it? Many thanks
Stop Microsoft's nagware pop ups
Once more, I'm on a new computer which has reset all of Microsoft's nagware pop ups that remind me how to use a product I've used for literal decades. "Did you know you can click here and do this". "I see you went to a new menu, did you know you could see ____ in this menu but you can't actually see it because this intrusive pop up is blocking it?" "Here is another pop up that deselected the cell you were currently typing in and you didn't notice is for 5 minutes so you have to redo everything you just worked on. Sucks to be you." How the hell do I get this nagware garbage to go away forever and never, ever, ever, ever, ever, ever come back?!Microsoft 365 Apps Admin Center - Inventory Errors Out
Been running into issues the last few days as I try to swap a handful of devices to a different update channel. I'm able to browse to the Microsoft 365 Apps Admin Center (https://config.office.com/), however when I go to Inventory it throws a generic error (it's been happening for 3 days now): There was a problem showing the security update status information. Please refresh the page or try again later. 00000000-0000-0000-0000-000000000000 This was working earlier this week (Tuesday 5/13/25) but as of Wednesday it was "broken". Checking to see if other folks are running into this or if we're just the lucky ducks. Several of us within the organization have run into the same error so it's not isolated to any one individual.
Add Letter Into Number
I am wanting to see if there is a way to have a letter inserted into a cell that already has a number if another cell meets a certain criteria. See below for example. Cells in Column D are prefilled with a number. Once the adjacent cell in column L is filled, I would want it to put a letter in Column D after the 25 as you see. Anyone know if this is possible? If so what would the formula be? I have racked my brain trying to create it but I'm coming up empty.
Conditional Formatting for multiple range
I wonder can we make conditional formatting in excel to hightlight certain values in multiple ranges in a couple of certain columns? A B C D E F G 1 value Percentages of Total value Percentages of Total value Percentages of Total 109 61 122 61 145 61 50 28 54 27 67 28 19 10 21 10 25 10 178 100 197 100 237 100 2 Values Percentage of Total Values Percentage of Total Values Percentage of Total 1 0 1 0 2 1 0 0 0 0 1 0 1 0 1 0 2 1 4 3 4 2 6 3 11 8 14 9 15 8 17 13 18 12 23 13 17 13 21 14 27 15 20 15 22 15 27 15 31 23 32 22 36 20 28 21 31 21 34 19 130 100 144 100 173 100 3 Values Percentage of Total Values Percentage of Total Values Percentage of Total 76 45 85 46 102 46 4 2 4 2 4 1 29 17 32 17 37 16 7 4 7 3,83 8 3 20 11 21 11 26 11 6 3 6 3 6 2 12 7 14 7 17 7 3 1 3 1 3 1 7 4 7 3 8 3 1 0 1 0 5 2 3 1 3 1 3 1 0 0 0 0 0 0 0 0 0 0 0 0 168 100 183 100 219 100 so for example all 3 tables in a worksheet, all tables had different row lengths and i want to hightlight automatically 3 largest percentages values in range between "Percentage of Total" and "100" which is the sum of percentages in each tables.so for Table 1 all of cells between "Percentage of Total" and "100" will be hightlight,for table 2 highlight values are 23 21 15 (1st column), 22 21 15 (2nd column), 20 19 15 (3rd column)and for table 3 it would be 45 17 11 (1st column), 46 17 11 (2nd column) and 46 16 11 (3rd column) Is there a way to do that?
Teams Posts & Files Tabs - making Files Tab as the default AND Renaming the General channel
Hi there Two queries. Is there a way we can make the Files the default tab when opening Teams, currently this is Posts and most people are looking for a file, so it becomes an extra click. Alternatively can we change the order of the Post and Files tabs, so Files comes first. Re the General folder - is there a way to rename this Many thanks RanaUsing Filters to Auto-Update Complex Formulas
Hi, This is my first post here. Hoping someone here may be able to assist me. I have the below spreadsheet. There is currently 500 rows of data. At the Top is a Summary Grid with formulas summarizing the data below (Rating, Employee Level, etc. ) I'm also showing an example of one of the formulas in Cell F3. The other cells contain similar formulas. Ask: How do I get the Summary Grid to only display the data based on the rows visible, which is determined by Column T filter selections. For example, if the user selects "Level 4 Manager 2" and this manager has 10 employees, how do I get the Summary Grid to display just the data based on those 10 employees (versus the total 500). I've seen videos/sites that use the Subtotal or Aggregate formula, but it appears those can only be applied to specific functions, not a more complex formula. Is this possible?O365 - EU and China
Hi Worldwide Org - based in EU - they have a Tenant - and are about to migrate all users personal files from fileservers to OD4B - (into the EU data center) However there's a subset of users that resides in China - and apparently there's some China regulations saying data "must" reside inside China - (china users connection to the EU Tenant/OneDrive are very slow) so how do I solve this "architecture" in the best way possible? Multi-geo is not an option as China aren't supported. Does the Company create a SharePoint Farm in China and let the users in China have their OD4B on that - what about collaboration on documents, ediscovery etc. etc. between EU/China users in those scenarios? Does the company create a separate Tenant inside China and initiate the B2B capabilities in the EU tenant? How have others solved this?Excel 2021 Dark Mode Not Working – "Switch Mode" Button Unresponsive
Hello, I’m using Microsoft Excel 2021 (Version 2504 Build 16.0.18730.20122) 64-bit on Windows, and the Dark Mode feature is not working despite multiple fixes. Here’s what’s happening: The "Switch Mode" button (under the View tab) does nothing when clicked. Excel’s UI theme is set to Black (via File > Account), and Windows is in Dark Mode. Cells remain white—no dark grid or true dark mode applies. Troubleshooting steps I’ve tried: Updated Office to the latest version. Manually set the registry key UI Theme to 3 (Black) under HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common. Repaired Office installation via Control Panel. Disabled add-ins and reset Excel settings. Question: Is this a known bug in Excel 2021? Are there additional registry tweaks or workarounds to force dark mode for cells? Thank you for your help!IF OR statements
I have a cashbook spreadsheet which in Col A shows money in, Col B shows money out, Col C shows the cost code, and Cols D, E, F, etc one for each of the cost codes. So, for example, if there's a cost of £100 in Col B and a "Gardening" cost code in col C then the value in Col B is copied over to, let's say, Col F which is the Gardening costs column. That's easy. In the Gardening costs column is F and there's a gardening cost in row 10, we have: =IF(C10="Gardening",F10=B10,"") But suppose there's money coming in, for example, a refund for gardening overcharged. This income would be shown in Col A. What I want to do is to repeat the above but add something along the lines that if there's an income in Col a, that should also be moved to the gardening column but as a negative amount. I've struggled to write this without success. any help greatly received! Thanks to the community. G.PowerQuery not reflecting changes to filenames in Sharepoint Library
Hi All. I've got a simple SPO library with files that I need to query within Excel via PowerQuery, I'm using the Query Type SharePoint List rather than SharePoint Folder because I need other metadata from the library. So far so good, query works great, now the issue, IF I change the filename in the library it does not update in the PowerQuery results. New files will appear OK, other metadata changes appear Version numbers update. Simply the filename will not show the change, Cleared the PowerQuery Cache, that didn't work. File in Library Result in PowerQuery If I create a new Query in a fresh Spreadsheet, same result? Any suggestions greatly appreciated. Cheers Russ
Recent Blogs
- 2 MIN READWe've eliminated the unused space between the ribbon and your canvas, giving you more room for what matters most.May 08, 2025
- 3 MIN READOneNote for the web went through a series of enhancements made over the past few months, designed to elevate your note-taking experience and boost your productivityMay 07, 2025
