excel
44971 Topicschart change
I have an excel spreadsheet with several tabs. 4 of those tabs have charts. On my first chart, the information is no longer displaying correctly. I have deleted and readded, compared formating, used google. I cannot figure out why it is different. Only one of my chart lines is showing, the rest are so small I can barely see them and the heading color key won't display. - If I post this twice, apologies, I backed out accidentally16Views0likes0CommentsChart Changed
I have an Excel Spreadsheet I have been using for several years. Today, one of the tabs is no longer formated like it should be. It is not displaying the color Key and the lines of my chart, save one, are so small you can barely tell they are there. I cannot figure out what happened or how to fix it. Every other tab is how it should be. I'm not sure how to attach a screenshot here. I have deleted and readded. Same result. I have checked a previous document and compared formatting.11Views0likes0CommentsSort In Protected Worksheets
Why is there a protection option to allow sort on a protected worksheet - but it doesn't work? I have found dozens of posts on work arounds, but why oh why do we need work arounds. Just make the built in options work! I want users to be able to see all the data in a table but not edit any of it - that works. I want them to be able to select locked or unlocked cells, to allow them to copy data - that works I want them to be able to filter data by different columns - that works. So why not Sort???6Views0likes0CommentsIssue: 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.44Views0likes1CommentUrgent Escalation: Excel Freezing and Hanging Issue Not Resolved After Troubleshooting
Dear Microsoft Support Team, Greetings. I would like to escalate an ongoing issue with Microsoft Excel that remains unresolved despite extensive troubleshooting. Today, I spent more than 2–3 hours with your technical support representative, who remotely accessed my system to diagnose the issue. During the session, multiple troubleshooting steps were performed, including a complete uninstall and fresh reinstallation of Microsoft Office. Unfortunately, the problem still persists. The issue is very simple but critical. In one of my Excel workbooks, whenever I try to delete even a single row, Excel immediately freezes and becomes unresponsive. After that, I am unable to continue working, and the application has to be force closed. This is significantly affecting my productivity and delaying important work. Since the issue was not resolved after the previous support session, I request that this case be escalated to a senior technical engineer for further investigation. Kindly help identify the root cause and provide a permanent resolution at the earliest. Please let me know if you require any additional information, logs, or diagnostic files from my end. I am available to cooperate with any further troubleshooting required. I look forward to your prompt response and a quick resolution. Thank you. Kind Regards, Farhan Mirza67Views0likes1CommentExcel Help
Is there a way (either formula or macro /something) for the following. I have 2 different spread sheets (files) open at the same time. First is called Time Card Second is called Wages Time Card will have a staff members details as well as dates and shift times. (20 Tabs for different staff members and their details) Wages will have Tab 1 - Summary of all staff names, hourly rates, hours worked for each day and gross amounts to be paid Tab 2 - 20 payslips with the above mentioned details, but payslip style. Lets call the first person Joe Deer I need something in Time Card next or close, to this person's name, when clicking it it will jump to his payslip in Wages sheet As mentioned. Formula or macro.. Guess anything will do. Thanks50Views1like3CommentsGetting data from Snowflake to Excel
Hello I have multiple no technical users and am trying to find a way to setup a snowflake query for them and then let them refresh it whenever they want or on a schedule, but I couldn't find a good solution this what i found so far: ODBC (Not great for non technical users needs setup on each user desktop) Power Automate (Needs Power Automate Premium which we don't have) Third Party tools (Expensive pricing models) Through Power BI (We want to separate this process from power bi) Any suggested solution please!Solved71Views0likes3Comments