Feedback by UserVoice

Øystein Johnsen

My feedback

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

    We’ll send you updates on this idea

    Øystein Johnsen supported this idea  · 
    An error occurred while saving the comment
    Øystein Johnsen commented  · 

    PIctureLinks are useful in a number of places, but they suffer from a serious problem if you use them in a workbook with vba code.

    If a pictureLink contains an actual link, ie that its formula property is set, execution of VBA code slows down by a factor of 100. You can get around this by temporarily setting the formula property to "", run your code, and then set it back at the end of your vba macro.

    But if you have another workbook with picturelinks in the same instance of Excel that you might not control, this also slows down execution.

    If you had a an application property to control this, that would be a big improvement, for example Application.DisablePictureLinks=true, this would be useful.

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

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Øystein Johnsen commented  · 

    You can modify the registry to allow for this functionality. By default Excel 2016 opens new workbook in an already running instance, but this causes problems for large and complex workbooks. One thing that may cause this problem, is if you have a workbook with picturelinks, often used in dashboard type applications. If such workbooks are running macros with the picturelinks active, Excel will grind to a halt. If you are running one Excel instance, all the other workbooks also become unresponsive.

    It can be resolved by following the steps outlined in the Microsoft support article below. Works perfectly. Sometimes you want to open multiple workbooks in the same instance anyway, and this still works if you open multiple workbooks from within Excel, it only opens a new instance if you open the file from the file system.

    See
    https://support.microsoft.com/en-us/help/3165211/how-to-force-excel-to-open-in-a-new-instance-by-default

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

    We’ll send you updates on this idea

    Øystein Johnsen supported this idea  · 
  4. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Øystein Johnsen shared this idea  · 
  5. 564 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    started  ·  95 comments  ·  Excel for the web » World Readiness  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Øystein Johnsen commented  · 

    Excel online is completely unusable as a result of this. The desktop version works well with UI in English, regional formats in Norwegian and of course all formulas are in English. Why should the online version be different? We recently tried to use Excel Online for certain documents, because we need to have multiple people working at the same time for certain documents, but then you have to choose between having region set to US, or if region is set to Norway, functions in Norwegian.

    I know real time coauthoring is coming to desktop Excel, it is in the insider preview fast ring atm, but regional settings should not control formula settings, UI language should control that.

    You really need to fix this asap, otherwise we can not use it.

    Øystein Johnsen supported this idea  · 

Feedback and Knowledge Base