Forum Widgets
Latest Discussions
Problem: Excel opened the first file quickly, but the second and subsequent files very slowly
Problem: Excel opened the first file quickly, but the second and subsequent files opened very slowly when launched externally (double click from Explorer or using excel.exe "file.xlsx"). Environment: Windows 11 Pro 25H2 Office 2021 Pro Plus Clean Windows installation Clean Office installation Modern hardware (Intel 13th gen + NVIDIA RTX) Symptoms: First Excel file opened fast Second and subsequent files became progressively slower Opening files from inside Excel was always fast Drag & drop from Explorer into an existing Excel window was fast Word did NOT have the problem Reinstalling Office did not solve it Disabling Defender, Protected View, StartAllBack etc. did not solve it Cause: Registry DDE handler related to Excel shell open behavior. Registry key: HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec The (Default) value was empty. Fix: Set (Default) to: [open("%1")] Then reboot Windows. After that: multiple Explorer launches became instant again no more progressive slowdown Excel external opening worked normally again Important note: On other healthy machines the value may still appear empty, so the fix may actually force Windows/Excel to rebuild or refresh the COM/DDE association/cache rather than the value itself being universally required.
Excel 365: Unexpected Predictive Behaviour Causing Retroactive Cell Changes in Structured Dataset
Hi everyone, I’m posting this to share an unusual and potentially important issue I encountered in Excel 365 this morning. I’ve already submitted a detailed report to Microsoft via the Feedback Hub, but I felt it would be useful to document it here for visibility and to see whether anyone else has experienced something similar. While entering data into a structured table (a parts‑catalogue workbook), Excel began exhibiting behaviour that did not match Flash Fill, AutoFill, or the standard predictive typing feature. Specifically: Grey predictive text appeared beyond the cursor and extended into cells below the active cell Excel began rewriting previously validated cells in the same column Each time I pressed Enter, Excel updated earlier rows based on its latest inferred pattern Attempts to correct earlier rows caused further cascading changes Undo did not revert all changes The behaviour resembled an AI‑style inference engine trying to “learn” my pattern, becoming progressively more confused This was not the normal predictive typing behaviour (which only shows grey text inside the active cell and does not affect other cells). The behaviour stopped only after I clicked the Flash Fill button twice, which suggests an internal state reset. I’m not seeing the issue now, and other workbooks behaved normally, so this appears to have been a transient internal mode rather than a persistent setting. I’m sharing this here because: it caused silent data corruption in a structured dataset it may indicate an experimental feature or feature‑flag activation others working with structured data may want to be aware I’d be interested to know if anyone else has seen similar behaviour If helpful, I can provide the reproduction steps, screenshots, and the engineering‑style report I submitted to Microsoft. Thanks, John
Error on regression analysis
Hello everyone, I want to perform a regression analysis on my survey data, but I keep getting this error message: “Regression - The RGP() function returns an error value. Check the input ranges.” I’ve since figured out that it’s due to a specific row, but I couldn’t find any incorrect numbers, letters, or anything else in it that would trigger this message. Does anyone know what might be causing this and how I can fix the problem? Thanks in advance!
Help with Formular to keep constants
Hi I have 2 rows for percentage values as per this table. C3 will be the value of (C2 + B3) / 2. However I need to check for an empty value so my calculation is =IF($B$3="",0, IF($C$2="",0,($C$2+$B$3)/2)) - I hope that is right, A B C D E F G 1 Name Name Name Name Name 2 50.25% 70.78% 60.14% 24.86% 53.64% 3 Name 60.12% 55.18% 65.45 4 Name 45.58% 47.91% I then need to copy(drag) the cells across and down and provide the correct values, so it uses the same top value and left value. For example D3 will be =IF($B$3="",0, IF($D$2="",0,($D$2+$B$3)/2)). C4 will be =IF($B$4="",0, IF($C$2="",0,($C$2+$B$4)/2)) and so which will alter as I drag down or left and it keeps using the correct column value and row value based on what column/row it is in. What I am doing now does not retain the right column or row value. I hope I make sense. Thanks.
Summarising a number of sheets to a front sheet.
I have a simple spreadsheet with Sheets for individual investment details. The TABS contain the name of the investments eg BP I am trying to put together the front sheet summarising certain data from the individual sheets, one row per sheet. Data such as Investment Name and Value. How can I do this please?LAMBDA : function generating #NAME error
Hie, I juste discovered Lambda function, and i have a problem. I created a lambda function that compute a cubiqual polynomial with the code : Poly3:=LAMBDA(_a, _b, _c, _d, _x, ((_a*_x+_b)*_x+_c)*_x+_d) Excel accepte de function, but when putting the function in a cell, it generate a #NAME error. I Debug the Cell, and it seems that de fith argument is refused, with #NAME error ! but the data pasted to the function is a basic computed value ! I don't see anithing rong in my function. Does anyone have an idear, or explaine me what rong in this code ?
MATCH formula anomaly?
Can anyone explain this? If I simply type 490.44 and then calculate 490.44 as 490.44/40*40 (or even directly B3/40*40) excel recognizes both as equal through a simple A=B calculation yet not with a MATCH calculation. What is more odd is any other number I use does not cause this error...
