Forum Widgets
Latest Discussions
Chart 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.MSO Files being randomly renamed while open on desktop
Not sure if anyone is facing this issue - but I have been facing this for 2 months now and it is really really frustating..! While working on Excel, Word or Powerpoint - a lot of times (very frequent now) the filename of the open file (on which we are working) suddenly gets saved as a random number (e.g. 12456.xlsx). If we aren't alert - if you close this file - "You lose the original file from the original location". Gone - absolutely disappears. I tried to do some research on the issue and found - Closing Excel App and reopening will give you the randomly named file in 'recent' list - however you can't open it. Checked the hidden folders and found same name file in '.temp.upload' folder, but without any .extension Renamed this file to .xslx and I got all my data back. However - if you do not rcover your file on same day there is a chance that you lose this file forever. I understand now by some online surfing that this is a Onedrive Sync issue. However, my broadband is super - checked the data throughput for the instance and it was continuous highspeed without any drops. This has become so frustrating now that I am thinking of moving out of MSO. It is very stressful and distracting now to be continuously alert and check the filename every few seconds. Does anyone else face this issue? Are there any solutions for this problem?
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???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 accidentally
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?
Scenario basic help please
Hi. I have a spreadsheet which calculates electricity usage and solar input etc. As the price keeps changing I am putting the new prices into the spreadsheet. I was thinking that I could use Scenarios or similar to be able to see what the bill would have been previously. I have looked at the Scenario instructions but I'm not quite sure how to use it (bit rusty in Excel recently). Is there a training video or similar I could watch. Any help gratefully received. Regards Bluey
