Feedback by UserVoice

Jan Wx, NZ

My feedback

  1. 12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    so isn't the workaround then to password protect your vba code which you want to do anyway or they can access the veryhidden via the VBA editor

    Jan Wx, NZ commented  · 

    Sorry, no, my macro's are password protected

    Jan Wx, NZ commented  · 

    I don't understand what you guys say I have just installed 2016 and it does NOT list my very hidden sheet. Where do you see this? It is not under
    Info>Browser View options
    and it is not under any of the Protect workbook options
    Did you put a password protect on your VBA container?

    Jan Wx, NZ commented  · 

    Since I use very hidden, I thought lets check. I use 2013, but do not find what you say under protect workbook. Is it a 2010 issue?
    What is far worse is that if a sheet is very hidden and you have a range name pointing to a range on it, then the sheet name is known via Formulas > Use in Formula > Paste Names ...
    With the sheet very hidden such range names should not display where they point to, because once you know the name, alll you have to do is create a sheet and create A1 = VeryHiddenSheetName!A1 and copy that across the sheet to see whats in VeryHiddenSheetName

    Jan Wx, NZ supported this idea  · 
  2. 112 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    Yes Ed that would be quite elegant too

    Jan Wx, NZ commented  · 

    Corey - you're not clear on why volatile functions are bad - they are just functions.

    If life was only as simple as a single table for data :)

    The reason to use indirects are multiple and functional. For example I do earned value and I need to sum from the current week to the end of the project. Next week the week has moved if you get my drift, but the indirect doesn't care, picks up the right starting point. Thus I can have formula which are regular and don't need exceptions. It is exceptions and difficult formula which are bad practice :)

    Other examples: I have a a test workbook here which semi automates data entry for testing. From the master list I have 43 sheets with on each some 200-500 test steps. Loads of indirects() sheetnames() and VBA :) Works like a dream

    Then I have a spreadsheet which generates some 1,000,000 lines of data using 100's of input configuration sheets again with lots of indirect()s to know where the data starts and stops. Works fine too, just wish sometimes we could set it to 10,000,000 rows. Big enough for you?

    Let's appreciate the diversity of functions in Excel, how we use it is up to people, not what you believe is bad practice. What I find so good is that it doesn't break.

    Jan Wx, NZ commented  · 

    Corey - so what that they are volatile - and yes indirect() is exactly why we want it :). It allows to dynamically build what one is wanting to retrieve.

    As for performance, I don't share that concern, I am an extensive user of indirect() and it does not give any noticeable performance issues. With sheetname() the user can change the sheetname and using the indirect you can then build dynamically growing workbooks.

    Jan Wx, NZ commented  · 

    of course one can calculate it, but it would be so handy if you could get the sheetname from a cell-reference without the hassles

    Jan Wx, NZ supported this idea  · 
  3. 43 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    gmoProXL - I fully agree with you, maybe I was too cryptic. If one can point to style then one can apply any formatting one likes (via that style)

    Jan Wx, NZ commented  · 

    It can actually be very simple - condition met -> apply style

    Jan Wx, NZ supported this idea  · 
  4. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    Long overdue - never use protection because one can;t insert rows anymore, so I use data validation checking that the lengh of the cell entry is less than a range named cell which either has a value of 0 or 10,000. Set that cell to 0 and they'll get a warning that they are over writing. Can be bypassed by deleting the entire cell, or by copying a value over it, but by and large it works, as all you want to do is stop people from accidental mishaps.

    Jan Wx, NZ supported this idea  · 
  5. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    Hi Kenneth - well I have already run out of votes and the ability to raise further issues :)
    I know what you say about the range - it is safer though to use the extended helper line so that you can't make mistakes.
    Indeed not using OneDrive - and haven't gone to Win10 as they claim all my data.

    Jan Wx, NZ commented  · 

    Hi Kenneth - after seeing your last post I thought this is how I can show the filter issue. How bizarre that I'm the only one with this problem - this should be everyone. Have a look

    https://www.dropbox.com/s/np5an9e9gcaw1xk/Filter%20bug.xlsx?dl=0

    Jan Wx, NZ shared this idea  · 
  6. 44 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    I'm not allowed to vote anymore but I vote for this!

  7. 273 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    Ah Bill - I have to thank you once more, as a few days ago I had a colleague with a similar problem.

    Jan Wx, NZ commented  · 

    Ah Bill - many thanks - conditional formatting and axis titles - that's where they are. Now Excel team can you see how important this is?!!!!

    Jan Wx, NZ supported this idea  · 
  8. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    As a Dutch native speaker I refer to this article

    https://nl.wikipedia.org/wiki/Graad_%28polynoom%29

    The correct term would be "graad" not "orde"

  9. 57 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    Hi Kenneth

    Are you able to save as xlsx please. This surely doesn't need macro's? I fully agree with your last comment !!

    Jan Wx, NZ commented  · 

    Hi Kenneth, that's not a real work-around one is better of VBA-ing as per Col's comment. Much better would be to have a fix. The object Comment knows it's parent (the cell) and thus the parent's location. Anyway we are second guessing all of that.

    Jan Wx, NZ commented  · 

    Very clever Col, but it shouldn't be needed in the first place :)
    For now I'll take your lead though as I doubt this will be fixed soon

    Jan Wx, NZ shared this idea  · 
  10. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    Hi Kenneth,
    Yes for sure it has to do with that but the visual representation is a string anyway and a string can be wrapped. All the need to do is wrap on separators like space, -, /

    Jan Wx, NZ shared this idea  · 
  11. 27 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    RobS - specified range I hope ;)

    Jan Wx, NZ supported this idea  · 
    Jan Wx, NZ commented  · 

    Go and have a look at doofa.com; it's an add-in, that's the down-side

  12. 12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    RobS you are so right.Developers I add: the principle of windows is that the user is in control of the windows and windows manager. Thus the setting of the window frame size, colors, fonts, etc, is up to the user. Modal windows stopping the flow of the user should be used sparingly. I know all revolutionary ideas of 30 years ago, but maybe you newby programmers to computing could do some reading and learning from those who have grappled with the issues before you.

    Jan Wx, NZ shared this idea  · 
  13. 12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    Yes that would make it also both horizontal and vertical! And there is an issue with value's versus strings

    Jan Wx, NZ supported this idea  · 
  14. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ supported this idea  · 
  15. 26 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    Yes it is - appologies

    Jan Wx, NZ shared this idea  · 
  16. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    Hi Paul, almost, very elegant, however, if there is only one parameter or if it is a blank cell, yours doesn't give the right answer. Great work though.

    Jan Wx, NZ shared this idea  · 
  17. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    Yes just select the column then grab the selection outline while pressing shift and moving the column

  18. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ supported this idea  · 
  19. 22 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ shared this idea  · 
  20. 55 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jan Wx, NZ commented  · 

    Oh yes for example provide the event for row/column insert / delete events please, please, pretty please. Many thanks I bow to you if you do it.

    Jan Wx, NZ supported this idea  · 
← Previous 1

Feedback and Knowledge Base