Date entered is changed to a different date
This issue has just started as far as I can tell. On an existing worksheet with the column formated to "date" 01/01/2025 format - when I enter a date of 01/01/2025 as for an example and hit "enter", the date is changed to 10/29/70! If I enter a date of 01/19/2026 it is changed to 08/27/63! and so on,..... it changes the field every time. if I enter those same dates by physically entering 01 slash 19 slash 2026 slash it will stay as I typed it - and will look like 01/19/2026 (or 01 slash 01 slash 2025) My husband is able to create a spreadsheet on his laptop that works correctly. When he sent it to me, the date fields did what I have stated above. So there must be something corrupt on my laptop? or Excel? I am running on the latest build (to my knowledge) Anyone? I am at a loss.. When entering a lot of data and dates - this is a real PIA. Plus - it was working just fiine - not sure what has changed. Thank you
Python in Excel is enabled but the runtime never downloaded
Hi, Python in Excel is enabled but the runtime never downloaded. Excel returns `/app/officepy/bin/python`, but the runtime folder is missing and HTTPS fails inside the sandbox. This is the ghost-runtime state. Please escalate to the Office engineering team to reset rollout flags and push the runtime package to my device. Excel build: 16.0.17231.20182 (Current Channel) ODT repair: fails with “couldn’t install” AppContainer: registered but empty Runtime folder: missing under %LOCALAPPDATA%\Microsoft\Office HTTPS: 400 errors inside Python sandbox I tried everything possible with Co-pilot's help. I tried reinstalling office full repair and ODT reinstall attempted. The runtime package never downloads. Apparently, This requires a rollout flag reset. Please help thanks
msoFileDialogFolderPicker compiler error
I have searched the net and not seen this issue. I developed a stand alone program in Excel Vba using msoFileDialogFolderPicker. It runs no problem. The function is as follows: Function PickFolder() As String With Application.FileDialog(msoFileDialogFolderPicker) If .Show = -1 Then PickFolder = .SelectedItems(1) End With End Function This was then added to a larger program with exactly the same code on the same PC and I get 'compile error' variable not found with 'msoFileDialogFolderPicker' highlighted.Excel Challenge - Pivoting poorly structured data
This is from an ExcelBI challenge. I thought it may be worth while posting my solution here as a demonstration of modern Excel methods. Challenge Like many of such challenges, the natural solution approach is to use BYROW but that creates the usual 'array of arrays' error. Solution: Gradually I am moving to a point at which I have no formulas showing in the workbook other than calls to Lambda functions. In this case, the worksheet formuloa is = PIVOTBYCATEGORYλ(OrderTbl) The function works row by row apportioning the amounts against the listed categories PIVOTBYCATEGORYλ // Groups and pivots table by category = LAMBDA(table, LET( normalised, BYROWλ(table, APPORTIONλ), // Identify fields from normalised table dimension, TAKE(DROP(normalised,,1),,2), category, TAKE(normalised,,1), partCost, TAKE(normalised,,-1), // Pivot by category return, PIVOTBY(dimension, category, partCost, SUM,,0,,0), return ) ); The function APPORTIONλ divides the amount between categories so each record within the source data returns a number of rows APPORTIONλ // Splits by category and assigns costs = LAMBDA(record, LET( category, TOCOL(REGEXEXTRACT(INDEX(record,4),"\w+",1)), amount, INDEX(record,3) / COUNTA(category), year, YEAR(INDEX(record,1)), region, IF(LEN(INDEX(record, 2)), INDEX(record, 2), "Unknown"), broadcast, B∕CASTλ(HSTACK(region, year, amount), category), return, HSTACK(category, broadcast), return ) ); /* FUNCTION NAME: B∕CASTλ DESCRIPTION: Broadcasts the terms of a vector over the shape of a second array */ B∕CASTλ = LAMBDA(vector, array, IF({1}, vector, array)); The key to making the formula work is the function BYROWλ that I wrote to generalise the inbuilt but over-restrictive BYROW function. The PIVOTBY function returned the required crosstab from the normalised data arrayCurrent Date and time per cell
I have a table with one column listing rows with a dynamic text box (open; closed) in the next column I would like to display the date and time when the status changes. The purpose is to show when a task was completed, I have used the now() function but it keeps refreshing, I need it stay the date The snip of the sheet below shows how is is currently working, so can any one help with some code for column J please. thank you LeeWelcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team
Hyperlinks not working on Macbook air
I have had an issue with permissions for accessing files with excel, in my Macbook Air (Apple M4 - Tahoe 26.2) for almost a year now. When I insert a link to a pdf and then I try and open the link, excel does one of three things. It either warns me that some files may have viruses etc etc and when I click open it opens the file it tells me that opening the file may cause issues etc etc and when I choose to open the file, it goes into the message above (1) and eventually opens the file it asks me to grant access to the file and it shows the file path and I need to click select, then it goes to the folder where the pdf is located and I need to click grant access - but when I do, it says that the file cannot be opened. I have gone into my system settings and excel has access to my full disk and files and folders. I have googled the issue and it was suggested to give excel access to the particular folder where the files are located but I don't know how to do this, other than in system settings. I have tried clicking on the folder where the files are located when option 3 above has come up but when I click on the folder, the grant access button at the bottom is greyed out. Can someone please suggest something, as it is driving me crazy now. I have inserted the links through the 'insert', 'add a link' button on the excel menu. Thanks.
