Forum Widgets
Latest Discussions
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.
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!
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!
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!
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.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. Thanks
PowerPivot 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=trueContext menu immediately closing after opening
When I try to open the context menu using my mouse, trackpad or keyboard button it opens and immediately closes again. It only happens when a certain workbook is open, also effecting all other excel instances. Other pop ups behave similarly, for example when i want to open the vba menu it always focuses on the workbook windows instead of the vba window, sometimes it changes so that the vba window gets focused and I cant return to the worksheet. Other pop ups arent effected, like for example any settings menu. When im in the VBA window the context menu works normally. When clicking on the windows part of the window e.g. the title bar, it works normally as well. In the trust center I disabled all vba macros, my vba code is disabled using Application.EnableEvents = False, even though I didnt have this problem with the code running before. Im having this problem for a few days now, so I have restarted my PC and excel multiple times. Its a really strange problem and I have no idea what the cause could be and it became weirder and weirder while I was trying out stuff before posting here, so im very happy about every possible solution :)Inserted Excel spreadsheet in Word not updating with added rows
Hi, I have inserted an Excel spreadsheet into my Word document via Insert --> Table --> Excel Spreadsheet. The contents of this spreadsheet show up in my Word document. However, if I insert a new row in Excel, while the row's contents show up and save in the Excel file, they do not appear in the Word document. This seems to be happening particularly if the new rows are added towards the bottom of the table. I cannot figure out why this is happening and there is plenty of space in the Word document for the new rows to appear. I have tried expanding the size of the table in Word and still no luck. Any assistance would be appreciated. Thank you.
