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?
Excel image not showing up on Windows users
I use Excel on Mac, and I've prepared a quotation list with all of the product images inserted into cells. When I send the Excel document to another Mac user, they are able to see the images. However, when I send it to a Microsoft user, they don't see any images in the document. I've attempted to upload it to Google Drive, but I encountered the error message below: Does anyone know a solution to this?
PLEASE HELP - Excel Horizontal Scroll Not Working
Hello all: I have an excel workbook that is many columns wide. I am on a Macbook Pro, Office 365. Scroll lock is *not* on, please do not suggest I turn it off. I can scroll in other workbooks. On this workbook, if I am selecting cells and trying to scroll horizontally, it won't continue the horizontal scroll beyond what is visual on screen. I am extremely annoyed, please help. Thank-you, Carl
Put a specific word in a cell based on the word in another cell
Hey everyone, I need help automating the categorisation of my bank statement in excel. I do not have microsoft 365. I want excel to look for specific words from my transactions eg Woolworths or McDonalds and then based on that, put another word into the categories cell. For Woolworths I want it to populate groceries, for McDonalds I want it to populate Eating Out. Etc. I would really appreciate the help and in the most basic way possible. I only use basic formulas, so array formulas are quite foreign to me. I have tried googling and nothing seems to work quite right. Happy to move columns around, but would prefer to keep Date, Amount & Description next to each other as that is the order from my bank statement download. I also don't need the Merchant / Category section in notes, but previous attempts led me to adding them. Thanks
