Forum Widgets
Latest Discussions
why is excel changing a formula in a locked and protected cell
I have quite a complex spreadsheet for use in my hobby of PBM - the spreadsheet includes an order form for players to submit instructions but with 1 player i am experiencing problems that I cannot fathom why it is happening Upon emailing my spreadsheet, one of the cells in a hidden and protected part of the form keeps changing, the formula changes for no obvious reason creating an error as it is then trying to bring in/read data from an invalid cell. This only happens with this 1 person, everyone else who receives the exact same spreadsheet has no issue, the formula does not change and the spreadsheet works as intended - just not for this one person. the cell is hidden and protected, the sheet is also password protected - it should not be possible for this cell to change but it does. Does anyone know why this might be happening? Both myself and the recipient of the spreadsheet run office 365 so there should be no issue with compatibility. as i say it is happening only to this one person, nobody else, and i do not understand why - looking for ideas on how to resolve this issue!!
Delete cells with 3 consecutive consonants
I submitted a question a little while back asking how to delete cells with exactly 3 consonants. The response I had was a huge help, but now I'm faced with a similar problem: How do I sort words by consecutive consonants? And if that cannot be achieved, how can I instead delete cells from a sheet in which a word has 3 consecutive consonants?
Pivot Table/Slicers Skipping Month
Hello, I have a Pivot Table where I use data slicers. A couple of the data fields are "Year" and "Month". When I updated the PT with data for October it treats the new data like it is November instead. I reviewed the following: I verified in the data that there was no incorrect month put in. So there is nowhere in the data where the "Year" = 2025, and the "Month" = "11". The data that was added to the table has the correct "Year" of 2025, and the correct "Month" of 10. I verified that the pivot table was set to view all months, which it is (there is data going back to Jan of 2024.). An additional filter is "Did we answer your question/concern?". This is set to No, and there were three "No's" in October. If I remove the data for October, then the PT removes the info showing for November. Including screenshots of the info. Does anyone have any idea why it is doing this?
Duplicate Styles warning
I'm using Office 365. A large spreadsheet I use almost daily recently started displaying the following warning when I open it. (The warning reads: "DUPLICATE STYLES This workbook has many duplicate styles which can slow performance." There is an adjacent "Remove Duplicates" button.) The first time I saw it, I clicked the Remove Duplicates button, did my usual work, and saved the file. I continued to see the same warning every time I opened the file. I worked with the file for nearly a month when I realized all of my custom Cell Styles had been removed from the spreadsheet. It took hours to roll back to a version of the file from before I first clicked on Remove Duplicates and recreate my work for the month. The odd thing is that if I open the same file on a different, newer computer, the warning does not appear. Questions: What do you make of the fact that the warning appears on some computers but not others? Is there a way to suppress the warning on my computer? Thanks in advance, Akira
