User Profile
PBellerose
Copper Contributor
Joined 9 years ago
User Widgets
Recent Discussions
Re: Force Office Files to Open in Desktop App (via link, from web parts.. in all cases)
cathyacbiker Just tried the "Copy path" option and removing the "?web=1" in a word document that points to an Excel spreadsheet saved on our Sharepoint site and it still open it in a web page.24KViews0likes1CommentHow to recover single occurrence of a recurring meeting
Hi, I have declined some occurrences and I also canceled occurences by mistake . I'd like to recover them. For declined occurrences, I tried to look them up in my deleted items but I could find the ones I wanted and ended in restoring a bunch of unwanted occurences. Still couldn't get the ones I wanted back. For canceled occurrences, I couldn't find any in my deleted items, so I started by changing the recurrence end date and send it again, which notifies all attendants. This seems to work but I will have to change the recurrence end date again to set it back to what it was and all attendants will receive another notification. Which is annoying. Is there any other way to recover single occurrence appointments that were declined or canceled?8.4KViews0likes2CommentsDisplay Power BI dataset sa a table in Excel
Hi, I was trying to get data from a published Power BI Dataset into an excel table because I need it to be formatted as a table, not a pivot table. I couldn't find any option to load Power BI dataset to table. It always loads as a pivot table. Any ideas ? Or am I just asking too much? Or maybe not using the right tool to create data exports to Excel? (csv exports from Power BI service reports aren't that easy to use for our end users)1.7KViews0likes8CommentsRe: OneDrive Client - Unable to sync shortcut
HansBrender After a few tests this morning, I can confirm that if a folder Sync was activated with any subfolder of the library, a "Add shortcut to OneDrive" will not sync. It will add the shortcut in your OneDrive cloud interface, but not locally. If you remove any Sync references to this library and try "Add shortcut to OneDrive" again, it will work.54KViews0likes0CommentsRe: Excel 365 Native Database Query Warnings
Rnishat0786 : Since this is a Global setting, I'm guessing this only applies to local machine and it should be set on all machines that will open the workbook? If so, anyone know what is the registry key and what it should look like? Thanks!35KViews1like2CommentsRe: How to export planner status reports in excel?
I have been using planner for a while and after implementing Scaled Agile Framework in our company I discovered Azure Devops which has all of these features built-in. It works on any platform (Planner does not like enterprise authentication) and could be simple as only using cards and a KANBAN up to full blown Stories, Features and Epics with intregrated teams. I would never go back to Planner. Honestly, I doubt Microsoft will ever implement the features requested here in Planner since they already have a product that does that.48KViews0likes1CommentRe: How to export planner status reports in excel?
Rob, Thanks for suggesting using Flow. But Flow does not read Planner properties like Labels, AssignedTo, Tasklist and BucketId and PlanID are internal IDs that are useless if you don't know where to look for the actual names. Again, thanks to Agile Product Development!131KViews0likes0Comments
Recent Blog Articles
No content to show