Forum Widgets
Latest Discussions
Excel Macros Spreadsheets Not Loading
I've spent some time with Microsoft Support (almost 3 hours, including uninstalling my MS 365 and reinstalling it), but I'm having an issue with my Excel Macro spreadsheets not loading at all. This is what I get each time. Also having an issue with non-Macro spreadsheets that I'm unable to use the Bold, Italic, and Underline functions (get the spinning wheel and then Excel Not Responding), as well as not able to use the Format function (get the same spinning wheel and then Excel Not Responding). I've been using these same Excel Macro Spreadsheets for over 15 years. Please help!
Line chart dynamic scaling of Y-axis
Micro$oft, please, please, pretty please with sugar on top, END the ensh*ttification, and get the Y-axis of a line chart to dyanmically scale with the data range that is being plotted. The range defaults to 0 as the lowest Y-value. The only way to change it, is to manually set the ax range, or use a work-around involving VBA. So... NO! This is crazy! It should be easy as apple pie for you lot to add an option to dynamically scale the Y-range in the chart, but I guess you are far too busy pushing people onto your crappy AI, which you can really stick some place the sun doesn't shine. Thank you.
Unwanted format changes on Excel worksheet in SharePoint
Hello - I've been working successfully with an Excel worksheet (.XLSX extension) that is published to SharePoint and has multiple Users viewing/updating data on this worksheet every day. Today, columns on this worksheet keep reverting back to varying widths (some way too wide and others way too narrow) despite going into the worksheet, re-formatting the column widths and saving the document. Other worksheets in the same workbook so far do not exhibit this behavior and are maintaining the desired column formatting (i.e., proper widths). I cannot figure out what is causing this unwanted formatting to happen and it has not happened before. I'm guessing this is an Excel issue, but might the SharePoint component be a factor as well? What are the potential causes of this, and what can I do to make the desired formatting remain and not revert back to the unwanted formatting? Thank you!Pivot Table TOP 5 vs Slicer
I create a Pivot Table, sort the data then filter on the TOP 5. I then create the Pivot Chart (horizontal TOP 5 bar chart). In my dashboard, I have slicers. When a Slicer filter is applied then removed, the Pivot Table and Chart do not go back to display the TOP 5 data but the whole set of data. Any simple way to ensure the pivot table / Chart recovers only the TOP 5 values (and not the whole set of values) after the slicer filters are reset ?
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???
