Sandbox subscription issue: "You don't currently qualify" for M365 Developer
Hello Microsoft Community Support Team, I am currently taking an training course on Microsoft Power Platform, with a special focus on building chatbots using Microsoft Copilot Studio (formerly Power Virtual Agents), Power Automate, and Power Apps. I wanted to set up a dedicated environment to practice the modules, configure cloud flows, and test the integrations. However, when I joined the Microsoft 365 Developer Program using my personal account, I encountered the following message: "Thank you for joining. You don't currently qualify for a Microsoft 365 Developer Program sandbox subscription." I do not intend to use this for commercial purposes; my sole objective is learning, studying the curriculum, and practicing developer scenarios for my training. Unfortunately, my university's IT administrator has disabled trial features on our student accounts, so creating my own developer sandbox is my only viable path to complete the practical exercises. Could you please assist me in manually reviewing my profile or enabling the M365 E5 developer sandbox subscription for my account so I can continue with my Power Platform learning journey? Thank you very much for your time and support. Best regards, Pablo
Excel for mac - Stocks data doesnt work
I was never able to get the Share Price or any other fields auto fill in Excel for Mac. It works fine on Windows or Cloud based Excel but not on a macbook. None of the options like Price, Volume... work. I tried to copy paste the formula for those fields from Office 365 to Mac but they never worked. Any ideas?
Losing Hyperlinks in Office 365 and OneDrive
Hello, first-time poster here. I hope someone can help with a dilemma I'm experiencing. I have an Excel 2016 workbook which contains 2 worksheets. The first worksheet consists of icons I inserted. I wanted the icons so that I could rotate them to suit my needs. Within the icons, I created a text box and inserted a hyperlink in each one that referred to a specific cell in the 2nd worksheet. In regular Excel, the links work great. However, when trying to test/edit in Office 365 or OneDrive, I find that all of the hyperlinks have disappeared, as well as the ability to create any new ones. This has really stumped me. Does anyone have any suggestions? Many thanks! 🙂
VLOOKUP help required
I am not sure whether to use nested VLOOKUPs or MATCH/INDEX and VLOOKUP to implement what I’m trying to do. On the main worksheet I have populated the Project Category using VLOOKUP based on the project lifecycle entered by the user. =VLOOKUP(H4,Category,2,FALSE) – this works fine and is using Lookup table 1. On the main worksheet, the user will enter in a score for each of the Project Elements (ranging from 1- unacceptable to 5-excellent). What I need to do is – based on the Category, apply the appropriate Weighting factor to the Project Element Scores (lookup table 3) and output that value into another column (called Project Element Weighted Score). Lookup table 1: Lifecycle Category 1-Investigation 1-Conceive 2-Definition 2-Design 3-Implementation 3-Build 4-Production 3-Build 5-Frozen 4-Manage 6-Phase out Started 4-Manage 7-Phased out 4-Manage Lookup table 2: Category Project Elements Score Output value weighting 1-Conceive Personnel 5 5 1 1-Conceive Personnel 4 4 1-Conceive Personnel 3 3 1-Conceive Personnel 2 2 1-Conceive Personnel 1 1 1-Conceive R&D 5 5 5 1-Conceive R&D 4 4 1-Conceive R&D 3 3 1-Conceive R&D 2 2 1-Conceive R&D 1 1 1-Conceive Infrastructure 5 5 2 I have in the weighted score field on the main spreadsheet and a VLOOKUP formula that was working prior to introducing the Weighting by Category concept. I can’t figure out how to include a lookup to to get the category and the corresponding weighting factor and use the correct weighting factor to apply to the score. I hope I’ve been clear enough - I cannot send my spreadsheet as it has cReference cell in previous sheet
How do I reference the value of a cell in a previous sheet without having to name it? I have tried the SHEETOFFSET formula, and it doesn't work on my .xlsm workbook. I am trying to pull in number of hours from previous timesheet in same cell, previous worksheet. From what I saw, =SHEETOFFSET(-1, J23) should return the value from the cell J23 in the previous sheet without having to use ='previoussheet'!,J23. Thanks!
Can't get a new subscription again
I has a problem for get new subscription. Detailed my case: - In Apr 19, i deleted profile (my subscription expired in Apr 19, 2024). - Got email confirm for deleted and Invite to Dev Program. - Today (Jun 20), after wait 60 days for delete current profile. - I visit join developer page and join again. - But, I got same screen in Apr 19, it include a old subscription expried and no any button for register new subscription/subscriptions. - I deleted profile again (Jun 20)... Also, i read all document and faq in Microsoft Learn for Microsoft 365 Dev Program but can't help more. I try click to Support in Navigation(Menu) bar in top of page, redirect to Microsoft ServicesHub and can't use my account for login. And my question: How can register subscription again, and how can contact to support via email?How do I manage my Microsoft Project? (notifications, deletion, and more)...
I finally got a license for Microsoft Project (instead of silly Planner which I cannot use for Agile Framework). However, I am still having some basic functionality issues with Microsoft Project Online. I am honestly trained on 2010 version of Microsoft Project, so a lot of these feature changes 1) How do I control notifications for Microsoft Project Online? First, I discovered there is these new notifications feature for Microsoft Project that sends out an email every time a even a sub-subtask (aka an action instance) is assigned. I do not want my coworker or the entire department to receive emails every time I edit a plan. (I mean 1 email is ok) but with how I work it can lead to like 60 emails.... So naturally I binged it which gave me this result.... https://answers.microsoft.com/en-us/msteams/forum/all/turn-off-sending-out-notification-to-all-members/84653dd8-187a-4178-9a94-96e96b86fca4 1. From the planning board, select the 3 dots (. . .) to the right of the plan's name. 2. Choose Plan Settings from the menu There are no settings under any of the 3 dots menu. So where are the notification settings for an entire project? 2) What is needed to access actual Microsoft Project Online? Normally I click on a project and simply edit it, but in the desperate search for the actual settings for a Microsoft Project.... I discovered today that I have a weird error. Something about permission to a SharePoint site. It did not give me this error before. I suspect that I might have to make my own PWA site. Can someone explain to me what this error is about and why the day before I could access Microsoft Project Online but now cannot? 3) How to delete a project? So, I was able to find a tutorial on this one, but I wanted to ask if there was a better way. https://answers.microsoft.com/en-us/msoffice/forum/all/deleting-a-project-from-project-for-the-web/a73789ef-b8be-4eb7-ba42-a9b2aaffe54b 4) How to control users that are part Microsoft Project Online? Because how many documents talk about need to be owner to control emails... I tried to make own group in hopes that will give me better control over notifications. But this led to a discovery that I am in like 15 different groups all with the exact same name as my section and members. So What settings in Groups are for a Microsoft Project Plan? Just an old fashion Project Plan user trying to understand how to use this confusing new Project version.Excel Table Appears to Automatically Expand but drop down list doesn't update
I used Excel 2013. I created a drop-down list that is based on an Excel Table via the Data Validation button on the Data ribbon. If I add or delete a row from the middle of the table, my associated drop-downs are updated automatically. However, if I insert a row of data at the very top or bottom of the list (range), even though the table appears to have expanded, the drop-down list does not update automatically. The Auto Correct options "Include new rows and columns in table" and "Fill formulas in tables to create calculated columns" are checked. None of the sheets on my workbook are protected.
