Forum Widgets
Latest Discussions
Practical use of row_delimiter with TEXTSPLIT
Let me be clear, I am not asking HOW to use the row_delimiter part of the TEXTSPLIT argument, I am asking WHY. Any use case I have come up with so far would be better addressed by Power Query. Even if there is a reasonable example, it still seems like it would have to be looped using VBA. Is material out there on what the developers had in mind for using it? If anyone knows, please share or share any example you have. (I'm in pretty much the same place with the ignore_empty and pad_with parts of the argument as well.) Thanks!
Stockhistory data integrity risk
Excel’s STOCKHISTORY function is misleading investors by using Refinitiv’s unadjusted feed. On Nov 1, 2025, DuPont (DD) spun off Qnity Electronics, reducing DD’s price by a factor of 2.3912. Every brokerage and charting provider adjusted the prior history to maintain continuity, but Excel did not—producing a broken series that invalidates returns, volatility, and backtests. This isn’t a feature request, it’s a data integrity bug. STOCKHISTORY must default to the adjusted feed or at least provide an adjusted:=TRUE option. If you rely on Excel for analysis, please upvote this so Microsoft fixes it before more users are misled.
Excel not able to write to Documents Folder
Hello, I was asked to help a family member who was having trouble writing files with Excel, and I have to admit their problem has me totally flummoxed; so, I was hoping for some help myself. When they open any Excel file, it says it is Read Only. Looking at document info confirms this, but we can't turn it off. Trying a Save As on the file generates a 0-byte file in the Documents folder and we then get a message that the file already exists, and we can't overwrite it. I set up a new folder and added it to their Documents library. This works perfectly with Excel being able to Read/Write any file in there. I thought it might be user permissions in Documents, but Word and Notepad can Read/Write in there without issue. The permission settings look good, and the problem is limited to Excel. The problem started when they downloaded a CSV file, so the first thought was it was a virus. They sent me a copy of the file which I checked in an isolated VM environment, and it appeared OK. Both of us ran virus scans that came out clean. Key differences between our environments are: that they are using Microsoft 365 and Norton antivirus, and I'm using Office 2016 and Avast antivirus. But both can out of scans clean. They have done a full reinstall of Microsoft 365 but the problem with Excel persists. If worse comes to worst, then there might be a full PC rebuild (ouch), or migrate everything to the new folder I set up and delete the old Documents folder. Ideally, I would like to remedy the cause of this issue which is why I'm asking for help.
Excel Security Warning:
Hello Everyone, I am having one strange issue. I am working on a excel which has few Power Queries and around 10 sheets. I have not created any macros. But in VBA Editor there are two VBA Projects. But they do not have any macros in it. Now the issue is, every time I open this excel file, I have been greeted with the "Security Warning: External Data connections have been disabled". and I need to press the "Enable Content" button every time. I have tried saving the file as .xlxs (from .xlam) but it didn't solve the issue completely, it does not throw error in some machines still and I have also tried to remove these two projects which has but no luck. Can someone let me know if this is a known issue? What are possible ways I can remove this warning (only for this file) as technically I am not using any macros. Any help would be highly appreciated. Let me know if you need more details. Thanking you.Can I control what is displayed in a FileDialog
Hello Excelers, Hope you are all doing well. Is there an option to limit the files displayed when you use something like: With Application.FileDialog(msoFileDialogFilePciker) .InitialFileName = "Book1" .InitialView = msoFileDialogViewDetails .Filters.Add "Excel Files, *.xls*" .Title = "Choose a File" (A way to limit files with a date range of say 7 days ago till yesterday .Show End With I want to limit the files displayed by a date of 7 days ago to yesterday. I know I can use the DateLastModified of a file but the question is how to incorporate this with the msoFileDialogFilePciker. Thanks in Advance! GiGiAdd VBA Code to an Option button dynamically
Hello Excelers, I hope you are doing well. I am back for some more help and here is what I am trying to accomplish: I have some code that would add x Option Buttons to a User form. x is Unknown but usually less than 15 but maybe more at times. I need to assign a macro that would return the newly created Option Button's Caption. In a Module I have: Dim objOptBtn as MSForms.OptionButton In a For i = 1 to x loop I have: Set objOptBtn = uFrmChoice.controls.add("Forms.OptionButton.1","objOptBtn" & i,true) With objOptBtn .Caption = i .snglTextWidth = Len(objOptBtn.caption) .width = snglTextWidth + 18 .Left = 10 .Top = TopLevel + 10 .Width = 400 .Height = 18 End With I remember there was an .OnAction "MacroNameYouWantToRunWhenOptionButtonIsClicked" But I do not see it in the Intelisense???? How can I assign code to run once the user clicks on a Option Button on the UserForm and return the Caption of that Option button? I am trying to ask the user to choose ONE option from a set of unknown options.
How to Account for Inflation
Attached I show an account balance forecast going out 20 years. But 20 years from now, $176,560 won't feel like $176,560 feels today. So how can I reflect a 3% annual inflation rate in each of the years? Each year's balance is based on many "ins and outs" of money, so I can't just calculate using a rate of return less inflation. Thanks in advance!
Filter cells in stead of full rows by color
Hi, I have an excel that contains a set of columns with values where in each column each cell has a certain fill color. Now I want to see per column only the cells with a specific color e.g. red. I tried the filter option on the columns, but that filters complete rows. I only want to filter the cells in a column. So in the image below I want to see only the red cells. So in column B no cells, in column C C3, in column D D4 and D5. The regular filter option would show B3 and B4 as well, because it would show the full row for C3 and the full row for D4. Any ideas on how I can achieve this? Thanks!i need the data from all the sheets in the workbook to link to one data sheet.
A colleague of mine made a data spreadsheet (lets call it SHEET 1), he no longer works for the company and over time the worksheet has been amended, so doesn't work like it should. There are several sheets in the workbook and all data that is copied into these needs to go into SHEET 1 (doing it itself, not manually). My question is when I download my data and paste into SHEET 2, how do I get it to automatically go on to the SHEET 1, taking only certain parts of the data, in this case B and F. The attached is just a small example of the data I need from SHEET 2. On SHEET 1 There is a list of numbers on the left and more, how can I get this data to filter itself onto SHEET 1 in the right column then adding the numbers on the left together. So, on SHEET 1, 160 -T will show 7 because there is 7 1's below for that Org. Sorry if i have made this sound long winded, I am awful at explaining. I have basic knowledge of excel but I cannot get my head around formulas. It should look something like this. Any advice would be great. ThanksPowerPivot not returning correct data
Hello, In the following link you will find a PowerPivot that is referencing 2 specific tables with Inv# being the common field between the 2 tables. The PowerPivot is bringing in Troy Ounces and Revenue by Invoice #, Fiscal Period and Department. Unfortunately the total Troy Ounce amount is being repeated under each Invoice #. It should be showing the respective troy ounce by what the invoice is recording. Is there a specific reason as to why the PowerPivot is not bringing in the correct troy ounce weight? Hope you can point me in the right direction. Here is the link: https://docs.google.com/spreadsheets/d/1QSu-QluTTAZBPsHtXhmkGoTezkPJv4Qp/edit?usp=sharing&ouid=103354753371375324640&rtpof=true&sd=true
