Fixing Hyperlinks in a Copied Worksheet (on an Apple Mac)
I have scoured this forum’s discussions about hyperlinks in a copied worksheet referencing back to the original sheet. Perhaps I missed it, but I didn’t find a solution to my specific problem, so I will start a new discussion. Apologies if a community wizard already answered it. I have a workbook with monthly worksheets, each showing the transactions into and out of a savings account. Each transaction goes into (and out of) one of several “virtual” accounts to reflect the purpose for which the money is earmarked, like property taxes, travel, etc. (called Account 1, Account 2, and so on in the attached) Each month’s worksheet has a section of hyperlinks, each of which ideally jumps to a specific account in the same worksheet. The attached example contains only four accounts, but my actual one has 23 with 31 columns and 98 rows. So the hyperlinks are helpful in navigation. Each month, I make a copy of the latest worksheet and rename it for the new month. The problem: the hyperlinks in the new, copied worksheet reference back to the “source” worksheet. With 23 hyperlinks, changing each one’s sheet reference (Edit Hyperlink...) every month is not efficient. Question: how can I (efficiently) make the hyperlinks in the new worksheet reference cells in their new worksheet? These are hyperlinks that are internal to the workbook, not to external URLs, so DonBici’s Feb 21, 2024 suggestion of a helper column doesn’t seem like it would work in this case, and I am not advanced enough for his VBA suggestion. Thanks!
Is XML in Power Query is broken on macOS
Hello, XML from Power Query seems to have broken after update (July 2nd 2026). I tried this on several Macs To recreate just create a new file. Power Query -> XML -> Choose any xml file For me it doesn’t work. It keeps loading endlessly Am I the only one? Is there a workaround? Thank you
Issue: numbered labels appear over the Excel ribbon when pressing Option
Description When I press the Option (⌥) key in Excel for Mac, numbered/lettered labels appear overlaid on every tab and button of the ribbon. The pattern is: Over the ribbon tabs (Home, Insert, Draw, Page Layout, Formulas, Data, Review, View): numbers 1 through 9. Over the Quick Access Toolbar icons: a descending then ascending sequence: 09, 08, 07, 06, 05, 04, 03, 02, 01, 0A, 0B, 0C, 0D. The labels disappear instantly when I press Esc. This does not happen in any other application (tested in TextEdit and Finder by pressing Option: nothing appears). Version information Excel version: 16.77.1 (Build 23091703) When checking for updates from Excel (Help > Check for Updates), I get the message: "This product is no longer supported. Support for this product has ended, and in-product help is no longer available or maintained." Troubleshooting steps already taken (no success) I have methodically ruled out the following causes: System Accessibility (System Settings > Privacy & Security > Accessibility): only Google Drive is listed, and it's toggled off. Input Monitoring: no items listed. Screen & System Audio Recording: no items listed. Switch Control: disabled. Excel KeyTips (Excel > Preferences > Accessibility): this section does not exist in my version of Excel — only the "Accessibility Checker" appears, with no KeyTips option or "Activation keystroke" setting. Excel Add-ins (Tools > Excel Add-ins): only "Analysis ToolPak" and "Solver Add-In" appear, both unchecked/inactive. Third-party automation apps (Keyboard Maestro, BetterTouchTool, Alfred, Raycast, Hammerspoon, Kutools, etc.): none installed on the Mac. Background processes (Activity Monitor): no suspicious process is running at the time the issue occurs, aside from normal system/Office processes. Office's internal preference files via Terminal (defaults read com.microsoft.Excel, com.microsoft.shared, com.microsoft.office): no key related to "KeyTips", "AccessKey", "Alt", "Option", or "Hint" was found. Question for support Is this a known behavior in older/unsupported builds of Excel for Mac (build 23091703)? Is there any way to disable this feature — whether through a hidden preference, a corrupted configuration file — or would a full reinstall of Excel be the only solution? Thank you in advance for your help.Excel Find / Command-F crashing on Mac Tahoe (Office 2019 / Excel 16.78) – anyone else?
Excel Find / Command-F crashing on Mac Tahoe (Office 2019 / Excel 16.78) – anyone else? Mac mini + Tahoe 26.5. Excel 16.78 (Office Home & Student 2019). Problem started after recent Tahoe update. Classic Find is behaving badly and often crashes Excel. Workflow: click/select a column Edit → Find → Find… or Command-F search for text or email fragments (ex: "kristin" or part of an email) Excel may crash or Find becomes unusable Things already tried: full Excel reinstall blank workbook test new macOS test user Office container reset / plist tests preference resets same Tahoe version confirmed Upper-right Microsoft Search appears, but that is not equivalent to classic worksheet Find for email-column workflow. Question: Is this a known Tahoe / Excel 16.78 Find bug or Search-routing issue? Has anyone fixed this or seen it resolved with a newer Excel build or update?
Column formatted as h]:mm:ss defaults to AMPM time upon editing cell
In Excel, I have a list of minutes and seconds as a 'timer for separate tasks' function, but even after formatting the whole column as [h]:mm:ss it is still reading as AMPM time. I also tried formatting the column as h:mm:ss, no change. The minutes and seconds read correctly in the sheet, but when I make a mistake entering the minutes and seconds, and double click on a cell to edit, it reads as an AM/PM. I am on a Mac. Screenshots to show the issue:Excel Functions
Find attached a matrix, and picture below I select Rare (0.5) in a cell and Modera (8) in another cell, i want function to return in a cell from matrix above. Like A (4) with green filled in. My inputs are Rare (0.5) and Moderate (8) and i want output cell to be Green filled in A (0.5) picked from matrix above. Like wise if the input cells are Possible (2) and Critical (50) then the output will be D (100) filled with light orange. I tried Index and Match function but failed. I can send the excel if you want. Please let me know what is the right function i have to use. Send the solution to mailto:email address removed for privacy reasons or email address removed for privacy reasons RegardsHow to split Excel file into multiple files?
I’m facing an issue with a very large Excel workbook and need some help. The file contains thousands of rows of data, and now it has become extremely slow to open, edit, and share through email. Sometimes Excel even freezes while working on it. Because of this, I want to split the Excel file into multiple smaller files, but I’m not sure how to do it properly without losing formatting or data. I tried manually copying rows into separate files, but it is taking too much time and there are chances of missing important records. I also searched online for solutions, but most methods seem complicated or only work for small datasets. This Excel file is very important for my office work, and I need a reliable way to divide it into multiple files based on rows or column values. If anyone knows an easy method, VBA solution, or any trustworthy tool that can split Excel files automatically, please share the steps. Any help would be greatly appreciated!
Help with turning categorical variable to numerical
Hello, I have a statistical coding assignment and one of my tasks is to turn a bunch of different numerical variables into categorical. I have to use a logical function and it works perfectly when I use eg. =IFS(A1=1, "Curly", B1=1, "Curly" ect...). However I have a few rows in my data set where there is no data for these cells and I need to have it in my formula where 'if A1:I1="", "" so that way I don't have #N/A. I know I could use find and replace and stuff but I have to have it in my formula to keep the cells blank when there's no data to output- if that makes sense. Any help would be appreciated!!
