Feedback by UserVoice

Walter Pelowski

My feedback

  1. 303 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      Walter Pelowski supported this idea  · 
      Walter Pelowski commented  · 

      I've had an issue the past couple of months where occasionally I'm unable to use the Modern Copy interface in SharePoint online (link here: https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/Announcing-File-Copy-Move-for-SharePoint-Modern-Document/ba-p/4884) to copy some spreadsheets over to another library. I get a really lousy and unhelpful error of "1 item wasn't copied". https://www.screencast.com/t/PEc6XaXJaC In finding a Excel 2017 and Excel 2010 article about this limitation I figured, "What the heck? Why not try it?" and lo and behold, by reducing the directory name in SharePoint Online by a few characters, it fixed the issue! I too am shocked that in today's day and age that this is still a limitation. (Literally the file is only 2 folders deep.) It is even trickier to troubleshoot when there is nothing in SharePoint Online to indicate that this was the limitation that was experienced.

    • 6 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        Walter Pelowski commented  · 

        I REALLY wish we had this. It would allow me to create reports that are much more valuable and useful to our company. Ultimately, I wish that Hyperlinks would become first-class citizens in the Excel PowerPivot data model as well by allowing calculated columns to use the Hyperlink function.

        This is one of those areas where I feel Excel is almost there. Since I believe usage cases are more motivating, I'm including an example of a report I've recently written that can be viewed via the hyperlink below. (I've trimmed it a bit and anonymized the information.) The report shows card records from Trello grouped by the email address of the person for whom we're doing some work. I'm able to do almost everything I want in Excel including using Power Query to dynamically pull the data from Trello via the API, group it together by both Card and Checklist, and give a report for those checklist items that are still due. It's so close to being valuable to people over our current process, however, being able to quickly give the person a hyperlink to click to complete the task is both more readable and actionable than trusting them to copy and paste a URL from the report.

        https://www.screencast.com/t/6EAQLv5eR6

        Walter Pelowski supported this idea  · 
      • 1,968 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          Hi all,

          I wanted to share with you that the new query caching mechanism in Excel has been deployed to Office Insiders starting from Excel version 1801 (build 9001.*). At this stage, we would like to allow some “baking” time as we monitor the feature health metrics.

          In this scope, we need your help to ensure a quality release! I encourage you to try the following scenarios and share your feedback:
          1. Run Refresh All on a complex workbook with multiple query dependencies. Does it work faster?

          2. Run Refresh All on a complex workbook with multiple query dependencies. Do you see any issues with your data?

          3. Refresh a single query several times. Do you see any issues with your data?

          - The Excel Team

          Walter Pelowski commented  · 

          FWIW, I don't see anything in the release notes about this in version 1801 build 9001.x
          https://docs.microsoft.com/en-us/officeupdates/monthly-channel-2018#version-1801-february-13

          Walter Pelowski commented  · 

          Some additional info on how to check/verify/change update channels.

          To find your Office 365 Version
          https://www.screencast.com/t/dXaqzPpiKX

          Information on Update Channels
          https://docs.microsoft.com/en-us/officeupdates/release-notes-office365-proplus

          Article about how to switch channels if your settings allow it
          https://blogs.technet.microsoft.com/odsupport/2017/05/10/how-to-switch-channels-for-office-2016-proplus/

          I've done this on my machine at work to get to the Monthly release channel while most of my colleagues remain on the Semi-annual Channel (Targeted)

          Walter Pelowski supported this idea  · 
        • 375 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            Hi Ken,

            Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

            thanks
            ash [MS XL]

            Walter Pelowski supported this idea  · 

          Feedback and Knowledge Base