Forum Widgets
Latest Discussions
Cannot add a worksheet to my Excel spreadsheet
I haver all of a sudden lost the ability to add worksheets to my spreadsheet program. I am using macros that both protect and unprotect the sheets that are currently there, but I want to add another sheet, and the plus sign at the bottom is grayed out as well as the 'Insert Line' line when you do Home/Insert. I have looked and I cannot find the setting that controls the addition of worksheets. Any suggestions???
Formula to compare a number as text and a partial match?
Hi, Trying to check if cell B is a match to A while also reporting any B that have a "0" missing in the front. (so a partial match?) I had used this formula. =IF(ISNUMBER(FIND(B2,A2)),TRUE,FALSE) Which tells me when there is a "no match", but I would also want the formula to let me know there is a 99% match - just missing a zero. is there a way to do this? thanks
Autocomplete not working
I have Microsoft 365 Version 2512: January 13, which is the latest update. I am operating Windows 11 Home Version 25H2. When I try to use the autocomplete facility in Excel it does not work. The 'Enable autocomplete for cell values' tick box & the one below in File; Options; Advanced are both ticked. I have tried this in all existing worksheets and IMPORTANTLY in a new blank worksheet. I have asked a friend to try it on his Windows 11 laptop with the same Excel and his does not work on his either. HOWEVER, it does work on my MacBook which is operating system Monterey Ver 12.7.6 & Excel Version16.89, which is an older version. There it works in both a new blank worksheet AND also if I copy the relevant file and paste into the Apple iOS system. I have posted questions on Q&A but have not had any response that indicates a valid reason for the problem or more importantly how to solve it. I would obviously like to speak to someone but I think this is likely to be impossible. It appears that autocomplete does not function in Excel in Windows 11? Can someone help?
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.
