Forum Widgets
Latest Discussions
Unwanted pasting of data in new raw or column
There is a strange property of excel - when I have a range copied (a cell or more) and will like to add new columns or rows excel will add the with the copied rang pasted. It is awful, as it take time and sometimes leads to a crash. Is there a way to prevent excel from doing so? By the way I wonder when Microsoft will produce excel that does not crash?
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 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?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
