chart 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 accidentallyChart 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.Signature Line - Cannot use certificate to sign
Hello, I work for an IT support section and am having difficulties with resolving an issue with signature lines. The users have recently received new Windows 11 devices with Office 365 enterprise applications installed (Excel, Word etc.). Signing signature lines on Excel workbooks worked when they were on Windows 10 on their older devices. They had generated user certificates on their previous devices that were able to be used to sign signature lines with. I've used our Networks trusted CA to publish new certificates to the Personal > Certificates on the current user certificates. I've done this the same way as I did when on W10. What I've found is that the certificate is able to be used to sign documents in Word but not Excel. Version of Office: Microsoft 365 Apps for enterprise 2605 16.0.20026.20182 I have found the following error in the diagnostic log for Excel relating to the error code -2147418113 which the Microsoft error code tool advised it was a Catastrophic failure referenced as "E_UNEXPECTED". None of the information obtained so far has helped me fix the issue. The only clue I can see is htat it works in Word and not Excel. Can anyone advise?
Sort 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???
Frozen App
I am a novice in Excel and my spreadsheet and all Excel functions are frozen by the appearance of a pop-up that includes a GoTo field first and a Reference field below that . I am guessing that this box is part of creation of some formula(?) but I have no idea how to clear it. It will not cancel, delete, or "x out"; I rebooted the entire computer hoping to reset but it didn't work and it has locked up everything. Is there a way to cancel this action and save my open spreadsheet? JT26
Excel 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. Thanks
Urgent 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 Mirza
