Forum Widgets
Latest Discussions
Revenue 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.
Excel Data Model + Databricks (ODBC) - Slicers Causing Major Performance Slowdowns
Hi everyone, I have an Excel file connected to Databricks via ODBC. The SQL statements are very simple, basically just SELECT * from individual tables. The tables are quite large, with the biggest one having around 5 million rows. They include sales data by daily transaction, sales data by weekly transaction, BTD data, and a dimension table with product information related to the other tables. In Excel, I created a data model, connected the tables, and added measures. The data is not loaded into worksheets, it’s only added as connections to the data model. The report itself consists of several large PivotTables and some charts built from the model. One of the user requirements is to have slicers controlling the PivotTables/charts. However, adding slicers slows the report down significantly. I’ve tried suggesting using PivotTable filters instead, which perform much better, but users strongly prefer slicers and still expect good performance. Does anyone have suggestions on how to improve performance in this kind of setup? Any best practices for using slicers efficiently with large data models connected via ODBC/Databricks? Thanks in advance!
Formual Error
Trying to create and excel sheet that shows the top 3 tour members for each month of the year but the formula i'm using to show me that information is showing up as an error and i'm confused as to why. I've added the formula i was using to find that information for me. =INDEX('Tour Attendance Tracker'!C2:C500,MATCH(1,(@'Tour Attendance Tracker'!A2:A500=A2)*(@'Tour Attendance Tracker'!F2:F500=C2),0))
Link doesn't work
We have recently started experiencing an issue when opening links within Excel on Azure Virtual Desktop. Our AVD environment is currently running the Version 2601, but the behaviour is very inconsistent, only a couple of users are affected, and the issue appears completely random. Interestingly, it works fine for most users both inside AVD and outside AVD. Affected users are receiving the following error message (screenshot below). So far, I have tried the following without success: Clearing the Excel cache Deleting the Excel container from the registry: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel Is anyone else experiencing the same issue, or aware of a fix/workaround? Any help would be greatly appreciated.Excel - single window, more files
How difficult it is to convince Microsoft team to fix major problems? I've recently switched to new Excel and I'm ...amazed. We used to be able to open multiple files, sheets in the same window. Opening multiple windows was possible as well. Now everything, even the same sheet is in new window. Every new window has it's own tool ribbon. Which is taking space. Ribbons do not synchronize - also slowing down the work. I get that there is and idea behind it. Probably more stable, easier to code or something entirely different that I do not know. But this is so annoying to work with. Is it possible to convince Microsoft that they should find a solution to problem they created?
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.Excel giving incorrect answer to simple multiplication
This is undoubtedly due to some quirk of Excel, but I was using Excel to illustrate how fast doubling increases things. I was using the old story about the person who would work for $ .01 for the first day, .02 for the second, .04 for the third, etc. My formula is essentially A2=A1*2 carried through 64 cells. The cells are all formatted as currency with two decimal points. The calculations are all correct until day 51. Day 49 = 5,629,499,534,213.12. Day 50 should end with $xxxxxxxx.24. Instead it ends with .20. Day 51 (should end with .48) ends with .50 and so on through the rest of the spreadsheet. This probably has something to do with floating-point calculations, but there should be a way for it to just work with the actual number.
