Recent Discussions
Formula result not showing in cell
Attached is my code and the formula result showing 50%. But in the cell where the formula is located, it displays a 0%. I have tried formatting the cell to be a number, percentage, and everything else, yet it still does not put the formula result in properly. Am I missing something?
SUMIF (or other function) if the cell value in either of 2 columns is >0
I want to sum the cells in column C if the row value in column A is >0 OR if the row value in column B is >0 (not AND). With SUMIF, I tried setting the search range to both columns A and B, but the result was very odd; I haven't yet figured out how SUMIF arrived at is sum. SUMIFS only works as AND, nor OR, to my knowledge. Thank you for your help.
How to restore a single file deleted 6 months ago - using M365 Backup?
My friend's company uses Sharepoint Online, but relevant folders are synced to their OneDrive so they manage everything in File Explorer. I have Microsoft 365 Backup enabled on their Sharepoint site. This company has all the parent folders in "Site Contents". These folders include Sales, HR, Clients, etc. I need to restore a single file out of Sales but it appears I need to restore the entire site first, sync the Sales folder from the site ending in /R0 to my OneDrive, then copy/paste from my File Explorer. Yes, I am a NOOB in Sharepoint. What's the right way to grab this file? And if it's ditching M365 Backup, then that's what I'll do, but I still need to get this file.
Excel formel
I am going to, have the same date pasted in about 50 places for labels. Request: I did Create a cell, AL2 - wrote, 27 Oct Then I want to create a formula in the 20 different places, that picks up 27 Oct from AL2, from the same Excel sheet. I have tried =!AL2, =$AL2... etc. but nothing works 🙁Chart from dynamic array challenge
Hi (Excel 365 v2601 b19628.20132 Current Channel / Windows 11 25H2) Initial post edited (& cross posted here on Jan 29, 2026) after further investigations In B6 below an array that dynamically resizes according to the 'START Year' & 'TOPN Cat' variables. The Chart is setup as follow: Select an empty cell > Insert 2-D Line chart Right-click > Select Data… > Chart data range > Select the Serie names & Values (C6:G12) Click Edit under Horizontal (Category) Axis Labels > Select the range with the Years (B7:B12) Check of the Chart data range: Changing 'START Year' works no problem: the Chart data range & Horizonal Axis Label range are properly updated Changing 'TOPN Cat' (the array resizes horizontally) screws up the chart: The Chart data range is properly updated but the Series & Axis Label ranges don't update accordingly Q: Am I doing something wrong, facing a limitation or is this something else? Tried to attach the sample file 3 times... it's available at: Dynamic_Chart_Challenge.xlsx Thanks & any question let me know Lz.Top n vs. Others in Excel
Hi all, I'm seeking some help because I'm kind of new to the more intermediate stuff in Excel. I have an Excel table with the following columns: Subcategory in column A, Brand in column B, Region in column C, Year in column D and Values Month in column E. I want to create a PivotTable and a Pivot line chart from this PivotTable that ranks the Top 5 Brands vs. Other Competitors by each region. For added context: There are 5 subcategories, 3 regions and 25 brands. Currently, I've tried grouping the remaining 20 brands as "Other Competitors" vs. the Top 5 brands within a selected region and possibly all regions (when no selection is made). I'm seeking a solution similar to this... Please mind the colours. I will sort those out later. But, the problem that I'm faced with is that upon selection of a region, the PivotTable won't update to the Top 5 brands of a selected region because they've already been grouped. How can I make this more dynamic so that I'm able to show The Top 5 brands vs. Others? Please help. EDIT: My operating system is Windows 10 (64-bit) and I use Excel 365 (Desktop version). For reference, I've attached a link to a sample file. https://1drv.ms/x/c/b2d878e32a062614/IQC1wcnwLICcQasOfnGcwKn0ASjpXp9xQ6rjnOP10Jal5cc?e=HaXEWd Thank you all once again.
Format Data Labels - Value from Cells
I have a spreadsheet (below) that I wish to show in two different ways: The actual numbers in each of the cells Domestic, Overseas, EU, and Non-EU as shown. The percentage values as shown in the %age domestic, %age overseas, etc.. Using the Format Data Labels and selecting Value From Cells, I can do this for any 2 of the 4 columns. However, when I try to select Value From Cells from the third and/or fourth column, nothing appears in the bar chart - it's completely blank (apart from the background colour.) I have uploaded the failing sheet, which can be downloaded by https://c3a-cyprus.org/test-work.xlsx. I'd appreciate any thoughts TIA NigelMicrosoft 365, Copilot, and Copilot Studio: January News Roundup
January was a strong start to the year for Microsoft 365 and Copilot. Throughout the month, Microsoft released several meaningful updates that highlight how quickly its AI vision is evolving — from enterprise-grade agent governance to hands-on productivity improvements in everyday tools like Excel. Rather than focusing on flashy one-off features, Microsoft’s January announcements show a clear strategy: make Copilot reliable, scalable, and deeply embedded into how people work, learn, and build solutions. Below is a full breakdown of the most important Microsoft 365, Microsoft 365 Copilot, and Copilot Studio news released during January — and why it matters. https://dellenny.com/microsoft-365-copilot-and-copilot-studio-january-news-roundup/Announcing Office 365 for IT Pros (2026 Edition)
Office 365 for IT Pros (2026 edition), the 12th in an eBook series going back to May 2015, is now available. Covering all the essential aspects of Microsoft 365 tenant management from Entra ID to Exchange Online, SharePoint Online, OneDrive for Business, Teams, data lifecycle management, information protection, and more, Office 365 for IT Pros is an indispensable companion for tenant administrators who want to understand how Microsoft 365 really works. https://office365itpros.com/2025/07/01/office-365-for-it-pros-2026-edition/How do I Stop Word Switching to Multiple Pages View
I have a high resolution wide screen monitor. Every time I open a Word document in full screen, it switches to the Multiple Pages view (typically 2 pages, side by side). I hate this view! I can't read 2 pages at a time. I always want a single page view. Does anyone know if there is a way to stop Word changing to this view? I am using Microsoft® Word for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20128) 64-bitWhy does original document close when saving a copy or selecting Save as and renaming a copy?
Recently I had a user ask why when she saves a copy or selects Save as and renames a file (basically creating a copy with a new name) Word closes the original file. No data is lost on the original, but it does close. She said it hasnt always done this, and I tend to agree with her. She said it used to create the copy but after saving it the original document was still open. Dont know if this is a settings thing or the result of an update. Thanks in advance for any tips or an explanation.
How to not overwrite cells in filtered table using copy and paste values
Hi, I have search for an answer to this question without satisfactory results. I hope someone here at the forum can help me out. The problem is that sometimes when I copy and past a value from one cell into many cells in a filtered table, the value also gets copied into invisible cells. I have found that it may have to do with the selected pasting option. Because it seems as if the problem only occurs (but I am not sure) if I copy and paste “values” (or formulas, or any other pasting option other than the default paste option). Is there any way to make sure that Excel only copies and past even formulas or values into visible cells? Example. Pic 1 - In the table below I will filter column A and only see the rows with “Jan”. Pic 2 - I then write “ok” in the first cell and copy and paste (using keyboard shortcuts, ctrl c, ctrl + spacebar and then ctrl v) that into all the rows matching the value “Jan”. Pic 3 – The result is fine. Pic 4 – I did the same thing but copy and pasted “values” into all visible cells instead of using keyboard shortcuts. The result is as you can see that all cells got the “ok”. Thanks in advance for any help given. Brgs, VictorAsian and Latin fonts
I have documents which are a mix of Asian and Latin fonts and I am having difficulty with footnotes and endnotes. Their numbersare in roman numbers and can be used in the midst of both the Asian and the Latin text passages. The first difficulty I have encountered is if I want to change the Asian font style say by increasing the font size then when I try to do this the footnote/endnote numbers change font size as well For example I start with font size 18 then I change the font style on only the asian font part using a style which puts the asian font to size 10 , but the asian font does not change but the Latin font does Clearly something is not set correctly - but what? My second question is regarding the Font dialog - this is how I currently have it set. But I am not entirely sure what the boxes marked actually do and would much appreciate clarification and each and/ or good tutorial link for using mixed font registers in general.
Best way to organize a café / drink menu with many items for easy scanning in Excel?
Hi everyone, I’m using Excel to manage a café-style menu that includes a lot of drink items, categories, and prices. The challenge I’m facing is readability. When everything is in one long sheet, it’s hard for people to quickly scan the menu and find what they want. I’m trying to make this more user-friendly for non-technical users, similar to how customers scan a real menu. In Excel, what approaches work best for this type of use case? For example: Separating items by category (coffee, cold drinks, specials, etc.) Using filters or tables to narrow choices Structuring the sheet in a more menu-style layout instead of a flat list From your experience, what makes menu-style lists easier to understand and navigate in Excel? Any practical advice would be appreciated.Excel authentication token reuse for access to Log Analytics
I have noticed that Excel is not able to reuse the authentication token when accessing Log Analytics workspaces if an expired token was renewed for a single sheet in a workbook. Scenario: 1 workbook with 1+ worksheets Each worksheet is a different query to LA (KQL query displayed in Excel for ease and consolidation) Access to LA is protected by the usual access controls (Conditional Access; Security Reader role + Session control) After a period of time, session and token expire and require renewal User receives a prompt stating the token has expired and needs to be renew User clicks on "Sign-in" and successfully completes the prompts (u/n+pwd+MFA) Expected result: The new token will be reused for subsequent connections to LA within the same workbook Actual result: User is prompted to re-authenticate for each and every connection in the workbook resulting in as many auth requests as there are connections Workaround: After successfully completing the first auth request, close Excel and re-open it and run "Refresh all" This successfully completes refresh of all data without any additional re-auth requests Is this behaviour by design or due to a configuration? Is there a way to address this so that the first token is re-used by all other connections without having to close and reopen the workbook?In form or report design view, cannot paste objects
Hello all. I have used MS Access for over 20 years as a user (not developer). I like to design forms and reports from scratch (not using wizards), and it is handy to copy and paste objects in design mode. This includes controls, labels, lines, buttons, etc. For example, in a tabular transaction-type report, I can copy already-formatted controls from the detail to the report or group footer and just edit each to be a sum. For the last several months, I can click Copy on the bar (or ctrl +c), but the paste icon does not light up and ctrl + v does not work. Sometimes if I wait long enough (like several minutes later), the paste function becomes enabled. It takes me substantially longer now to add new objects from the Report Design bar and reformat them to match the existing report or form. I don't know if this is an Access issue or a clipboard issue. I am able to copy and paste large volumes of data with no problem at all. I am thinking about re-installing my Office 365 (which includes Access). Has anyone else had this problem, and is there a solution? The version I have is Access for Microsoft 365 MSO (Version 2503, Build 16.0.18623 20076 64-bit)
Events
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
- Improvements in Microsoft 365 help you inclusively communicate and collaborate with math.Feb 02, 2026
- Storage overages in Microsoft 365 rarely come from a single misstep or event —they build up quietly over time —version history accumulating in active libraries, inactive content lingering long a...Feb 02, 2026
