What r/excel is talking about this week

I've been using Excel for years and never had this issue before, but for the past week or two, something seems to have changed and I can't figure out what's going on. Previously, whether I was...

Hello, I’ve got an issue which is maybe simpler than most queries on here, however my own research into a solution has brought me into a dead end somewhat. The issue: There is a master spreadsheet...

Even on my brand new work laptop, working with relatively small spreadsheets, I find Excel surprisingly sluggish. The worst example is the slight delay after pressing Alt to bring up shortcuts. My...

I am the only one very knowledgeable in Excel and Power BI in my team. My colleagues know Excel basic knowledge and nothing concerning Power BI. I have to create monthly metrics and I have to do a...

Hi All, Some of you may know of me as the curator of awesome-vba. Over the past few months I've been accumulating links to awesome public Excel workbooks and projects; such that I decided to...

Looking for some guidance, I think I am overthinking a relatively simple task. I manage an inventory for a supply chain and am looking to do a report that shows our slower moving items. We use...

Has anyone else been having issues with Power Query in Excel for the web since around November 5? I've got several workbooks that were refreshing just fine before, but now they're all failing....

Good evening. My job has work instructions that are scattered across tabs. I was wondering if there is a way to get certain information to appear and disappear based on a drop down selection. I...

I have ten worksheets. In each worksheet, column "E" is labeled "30-Day Cost". I want Excel to find the last value in column "E" in each worksheet and give me a grand total of all "30-Day Costs"...

Hi All, macro newb here I'm trying the below steps in my macro: 1. Get Data From File 2. Choose a file in a select folder 3. PowerQuery choosecol etc. 1&3 are easy steps that record macro can do....