office 365
6276 TopicsRegression: File hyperlinks with #Bookmark no longer work in Office 2601/2602
After updating to Office Version 2601/2602 (Current Channel / Current Channel Preview), file‑based hyperlinks that include a bookmark (e.g., C:\File.docx#Bookmark) no longer work. Office now rewrites the # as %23 and hands the link off to the default browser, which fails. This affects Excel, Word, PowerPoint, and Project. Rolling back to Version 2409 immediately restores correct behavior. I previously had a build newer than 2409 that supported both working file‑bookmark hyperlinks and Excel’s cell‑level dark mode, so this appears to be a regression introduced in the 2601+ hyperlink resolver rather than a local configuration issue. If anyone else is seeing this behavior, please upvote or comment so the engineering team can prioritize it. As noted, it is not just Excel, but that is the most pressing need for me.54Views0likes2CommentsExcel array question - spill VOWD based on forecast month
Hi, Can I have your help on a spilled question? I have the following table with information. Fore Month Jan-26 Feb-26 Mar-26 Apr-26 May-26 Jun-26 Jul-26 Aug-26 Sep-26 Oct-26 Nov-26 Dec-26 VOWD 2 - - - 3,983 15,203 11,779 2,083 - 1,742,162 1,696,156 116,267 1,162,366 - 2 - - 100,000 200,000 - - 500,000 650,000 300,000 - 466,000 - - 3 - - - 3,983 15,203 11,779 2,083 10,000 1,742,162 1,696,156 116,267 1,152,366 - 3 - - 100,000 200,000 - 250,000 250,000 650,000 - 400,000 450,000 - 100,000 4 - - - 2,000 15,203 11,779 2,083 10,000 1,742,162 1,696,156 116,267 152,366 2,000 4 - - 100,000 200,000 - 250,000 250,000 650,000 - 400,000 350,000 - 300,000 I would like to have a spilled array formula in VOWD column and the expected result is right there now. The logic is to grab the first 2 columns and sum up the amounts for the first two rows of data, and grab first three columns and sum up for the third and forth rows of data and etc. Thanks, Anna92Views0likes6CommentsRemoving a possible user selection from a slicer
I have a column field in Excel with 4 possible values. My slicer shows all 4, as it should. Three of the possible vales are alphabetic strings. One of the possible values is a blank field indicated by (blank) on the slicer. A blank is a valid value for this field in some situations, so I don't want to just ignore the rows where this field is a blank. But I would like to eliminate it as a user selection in the slicer itself. I thought checking the slicer setting, "Hide items with no data" would do the trick, but it doesn't appear to do so. Any tips on how that setting is supposed to work and/or why it might not be? (Maybe it has to actually be a 'null'?? No idea....)Solved78Views1like2CommentsRevenue structure
File Structure Reference Column A contains Client Names (e.g., A, B, etc.). Row 2 (starting Column B onward) contains month-end dates from Jan 2026 through Dec 2027. Columns B through the last month column contain monthly revenue values. The final column is the Total column (annual total calculation). 1. Termination Logic If a client terminates in a specific month: Revenue should appear normally up to the month prior to termination. In the termination month, revenue should become zero (or stop, based on effective date assumption). All future months (including months in the following year) must remain zero automatically. The annual Total column must update correctly based only on active months. The model must not require manual zeroing of future months — this should flow automatically once the termination month is specified. 2. Fee Update Logic If a client’s fee changes in a specific month: The revised fee should apply only from that month forward. All prior months must remain unchanged. The increase should not assume a uniform annual escalation. The updated fee must flow correctly into the next year without altering historical data. For example: If the fee increases in July 2026, then: Jan–Jun 2026 remain at old rate. Jul 2026 onward reflects the new rate. 2027 months continue with the revised rate unless changed again. It will be great if the formula works on Google Sheet as well.161Views0likes8CommentsNo stocks button/option
I have an active Microsoft 365 subscription through my Apple ID. But the Stocks button is completely missing from the Data tab. This issue occurs in both the Excel for Mac app (version 16.105.3) and Excel Online. My privacy settings for "Connected Experiences" are all enabled. I've already run the Office License Removal Tool and logged in again, but to no avail. Since the feature is also missing in the web version, it appears to be an issue with my Microsoft account configuration itself. Microsoft support can't see my settings and refers me to this forum. Does anyone have any ideas?84Views0likes2CommentsChart updates inconsistently when dynamic array resizes
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.545Views1like8CommentsCANNOT OPEN THE SPECIFIED FILE with tel:-hyperlink
Hi, I have several "tel:" hyperlinks in a Excel sheet (xlsm). Yesterday, they sended the phone numbers to whatsapp. But today i become the errer:"CANNOT OPEN THE SPECIFIED FILE". I saved yesterday a xlsx file as xlsm, after the conversion, the links were still working. What goes wrong?921Views3likes9Comments