User Profile
James_Price
Brass Contributor
Joined Feb 03, 2021
User Widgets
Recent Discussions
Re: Query updates in a browser
Hi Peiyezhu The Excel file is stored in SharePoint and I access it through a browser. I have an option to open in browser or open in app. If I open in the browser, I can't update using the Data tab, then Queries and refresh. Considering everything has moved to the cloud and the number of people who use this feature, I can't believe that this is not available by now and no one has a clue when it will be available. Hope this helps, James100Views0likes3CommentsPower query load failure in Excel online...
Hi team In Excel desktop, I created a power query linking a Excel file in a SP site in another tenant. I can refresh the data in the desktop but get an error when I try to do this in Excel Online, stating this is not supported yet. Does anyone know when this feature will be supported (as I can't understand why it hasn't been fixed by now). Many thanks JamesSolved1.4KViews0likes3CommentsRe: POL 2,000 project site limit...
Hi RodFromm and Paul_Mather, FYI in the past I seen an instance where there were a total of 8,000 projects with about 3,500 sites in the pwa site and 4,500 in other subsites (long story). POL still seemed to function fine. But I was always worried it would slow to a standstill at any moment. James771Views0likes1CommentRe: Meet the new Microsoft Planner: Manage all your tasks and plans in one simple, familiar experience
Thanks for this Sakshi. It seems the new Planner app will be available in April 24. The banner in Project for the Web (PfW) last month said PfW would be the new Planner (my understanding this will be Planner Premium but I could be wrong). The logical conclusion is that PfW will be Planner in April. However I have some clients who are worried about the implications of this and a couple of global customers have developed major addins due to the lack of functionality in PfW as the MS Project team recommended that clients move away from POL. Do you know where we can get more information on this, as I for one am quite worried how this will work. Many thanks3.5KViews0likes1CommentPOL: Changing a project's project site template...
Hi team I've want to change a project's site template. I've gone into Pwa settings and removed it but when I add the template again it's adding the wrong site template. Can someone help me with either easily changing the site template somehow or tell me how I can change the default site template when adding using 'Connected SP sites'. Many thanks for this James881Views0likes3CommentsPOL: Problem with changing a SP Designer workflow...
Hi Team, In POL, I created a project without workflows. I then created a simple workflow using SPD and then updated the EPT with the new workflow name. But when open a project of that EPT I get an error 'we couldn't find the project detailed page for this project'. But the PDP for that project is exactly the same as used in the stage gate section. Any thoughts on where I'm going wrong? Many thanks James461Views0likes2CommentsRe: Copy and paste to a PfW schedule...
Hi Paul, Sorry for the delay on this but I thought I'd replied last week... d'oh. So what I've been doing: 1. I copy a range from Excel (A1:A3 with values a, b and c). 2. In the Project Task tab, I select Grid and click on the 'Add new task'. This changes to a green outlined cell with 'Name' inside it. 3. When I paste, a black on white text pop up says 'The paste option is not supported'. 4. If I click again in the cell, I get the cursor key and this only pastes 'a b c' in the cell. Hope this helps Many thanks1.3KViews0likes4Comments
Recent Blog Articles
No content to show