User Profile
JKPieterse
Silver Contributor
Joined 9 years ago
User Widgets
Recent Discussions
Re: Spreadsheet Compare Output
I see you've posted this question three times. Please note we're all volunteers here :-) Perhaps not of much help, but I find the way PerfectXL Compare outputs the changes easier to work with. See perfectxl.com for their products. I'm afraid they're not for free though.6Views0likes0CommentsRe: Chart Vertical Axis based on formula
You mean the maximum/minimum scale of the axes? As far as I know you cannot have a formula that calculates it. You can however add a (hidden) series to the chart with just the minimum and maximum value you want it to use for the axes scale(s).15Views0likes0CommentsRe: Data Bar Min/Max
The length of a data bar represents the value in the cell relative to the lowest and highest value in the Conditional Format range, so in theory this is already what is supposed to happen. Can you try to explain what it is you are after as apparently this doen't do what you want?14Views0likes0CommentsRe: Which graph is best to show positive and negative relationship of different variable to one output?
plotting 6 variables in any meaningful way is very difficult. Perhaps you could try to create a 3D chart with only the two most important factors on the x-axes? You could expand that by having a grid of charts where the other variables are varied In my experience, there are often also interactions between the variables (a*x1*x2, b*x2*x3, ...). Have you taken that into account in your regression analysis?24Views1like1CommentRe: Active X controls are being converted to form controls and breaking
First of all, I would send a frown about this, this should not be happening IMO. Just open your file in Excel after it has been hit by the issue, remove all sensitive content and then click Help, Feedback, Report a problem. Check the add attachment box if you are allowed. I know there are files which Excel-o does not allow you to open, but I am not sure what you have to add to them to make this happen. This web page mentions removing XML maps from a workbook to allow on-line editing: https://support.microsoft.com/en-us/office/edit-a-workbook-that-contains-features-unsupported-by-excel-for-the-web-7220105d-97ad-4c35-95c8-58d4bbfd14af You could add a bogus xml map to your workbook on purpose :-)34Views0likes0CommentsRe: Forgotten Protection Password
What protection are we talking about? Worksheet protection (Review, protect sheet) Workbook protection (Review, protect workbook) Workbook encryption (File, Info, Protect Workbook, Encrypt with password) 1 and 2 are easy to remove, 3 is close to impossible.45Views0likes1CommentRe: Insert / Delete rows to table with locked cells (no-code solution)
I'm afraid there isn't a no-code solution. I suggest you vote for this idea: https://feedbackportal.microsoft.com/feedback/idea/11edffed-f753-ed11-9561-000d3a1f4367 That being said, perhaps an office-js add-in can be created which allows for this to work? What does your Office Script look like?33Views1like0Comments