Recent Discussions
SharePoint Agent use in Microsoft 365 Copilot
The article below mentions that agents created in SharePoint will also be able to use Microsoft 365 Copilot in the future. When will this be the case? Thank you for any appreciated answers. Andreas Frequently asked questions about Copilot in SharePoint80Views0likes1CommentA little confused by multi-tenant organization and teams
I've recently set up a Multi Tenant Organization with two Tenants, and set a few users to sync between the two. They all show up correctly in the opposite tenant users list in the admin centre, though sometimes it takes a while. Some seem to be added to the global address directory, but not others (I think possibly the first I added was, later additions are not). But most crucially, they do not seem to come up as people to do teams chats with, which is the most required feature. I'm guessing there is something I haven't set correctly, or some manual sync I am not running, but the example videos all seem to stop at showing that the user has appeared in the other tenant as a member, there's nothing showing how to then make use of this fact (such as including them in a teams chat). Can anybody point me in the right direction?30Views0likes1Comment#SPILL Error in Excel
I have been working on an assignment and using the XLOOKUP function to try to get a result. No matter how many times I do it, I keep getting the same answer. I have re-entered in the information countless times and can just not figure it out. I have also tried the VLOOKUP function. It says my spill range is not blank but I have no options to select obstructing cells or anything. I have the 365 Excel version. Any help?54Views0likes2CommentsWord to PDF, issue with gradient colors
Hello all, I've got a simple shape in Word filled with a gradient color. As I "Print" or "Save As" the Word document in PDF, the color gradient is not showing properly in the PDF file. In Word, I've already been in Options / Display / and selected "Print background colors and images", but it doesn't change anything. Please can somebody help? This is how it looks like while I'm in Microsoft Word And this is the PDF result as I do Print in PDF or Save As in PDF from the Word document.81Views0likes1CommentOneNote Android app doesn't provide source link.
OneNote Desktop app works fine without any issues. But OneNote Android mobile app is not providing source link when I copy any content from web. Is this a limitation in Android or design issue with OneNote? Please advise any alternate solution.40Views0likes1CommentExternal user with "Reviewer" permission not able to edit content controls
A document was shared to an external user by me with "Reviewer" permission. He reported that he was not able to edit contents of the content controls (regardless of the type). I validated this by sharing the document to my personal email and faced the same issue.24Views0likes1CommentShortcuts key don't work on Word, and the commands don't exist in keyboard shortcuts "customize"
I cannot use control+c, control+v, control+z, control+y, control+x or control+a on Word on my new computer. when checking Customize shortcut keys in options->customize ribbon, These keys are not assigned to any command, and the relevant commands (undo, redo, copy, paste etc.) do not appear at all, not inder "all commands" and not anywhere else. They do appear in the customize ribbon. I tried resetting the customize keyboard, and it didn't help.50Views0likes3CommentsStamp Duty Calculation
Hello, I have a SUMPRODUCT formula to calculate stamp duty in the UK below where F2 = the purchase price of a property. =SUMPRODUCT(--(F2>{0;250000;925000;1500000}),(F2-{0;250000;925000;1500000}), {0.03;0.05;0.05;0.02}) I want to edit this formula so that if F2 is less than 40000 then the stamp duty = £0 regardless of the above formula. Can anyone assist me please? Thanks, PatSolved24KViews0likes10CommentsImport Tab Delimited File from Clipboard
I'm looking to create a macro in excel to import a file from clipboard. I have tried to record a macro and that did not work. I do not want to enter a file name. I would like to copy from notepad and execute macro to import the data with pipe delimits. Sorry if this is a repeat, I ould not fine an answr anywhere. Thanks.Solved53Views0likes4CommentsDependent Drop Downs across multiple rows in a spreadsheet
Hello. I've been trying to create a spreadsheet that has a dependent dropdown column. However, all the guides and advice I've seen so far have been functional only when you only need a single cell or a small number of cells to have this drop-down. I'd like this function for a large spreadsheet that I will be adding to frequently. My first thought as a workaround is - is there a way to have data validation read an adjacent cell? The issue I seem to be having is that while I can set Data Validation to =INDIRECT(A2) - it applies that to every cell in the column, so it will only search A2. Is there a a way to have data validation go =INDIRECT("CellAdjacentToThisOne")? I would have thought there's a formula for identifying whatever is in an adjacent cell, but I can't figure out what to look for sorry. Failing that, if there's a workaround for getting dependent dropdowns to function through large spreadsheets, I'd love to hear it. I only have one layer of depdency - the first selection will draw from a wide range of options, but that will be the depth of it. I'm wondering if part of the issue might be that I'm in Office 365 - some of the tutorials use the Name Manager, but it seems to function or maybe it just looks different in the desktop version of Excel, so maybe it has some feature I don't have access too? Any advice would be appreciated.695Views0likes15CommentsHow to achieve easy file update on Powerbi repository
Hi, I am new to powebi and I am trying to understand if powerbi could be the answer to a challenge that I have. I receive a monthly excel report file (always with the same format and schema) from a partner. I would like to have a dashboard that visualised the report content. I can achieve this when I link the one file with powerbi, however, I am not sure how to handle the monthly increments. Do I need to have some kind of master file that every month I manually update with the data from the new file that I receive, or is there a smart solution where I can just drop the file into a repository and Powerbi will automatically fetch all files in the repository? Any ideas are welcome. Thanks22Views0likes2CommentsCreate a Power query or Dax to find Open Status more than 1 hour
Hi Team, I have the door table Here I want to find that whether door is being open continuously(having open status & not closed) for more than 1 hour for each DeviceId. Data Description: The Status column shows whether door is open or Closed. CreatedOn column shows time duration. DeviceId column shows Deviceid. My first requirement is: We need to add the minutes(createdon) between each row for same deviceid where the status = open. But where a status = closed (if closed comes in between open) we reset the number of minutes. So we sum by the previous value where status = Open - Something like If current status = open and previous status = open then sum the time and do the below: Sum(previous value + new sum) Where/if status = closed set time count = 0 Sum(previous value + new sum) is going to take into account only the consecutive open status >60 min for same divice id whenever status is closed, this Sum(previous value + new sum) will be reset to/equal to 0 So on the first open status, the count will be 0. Then the next open status it will be time between 2 open statuses, then on the third it will be the time between two open statuses add the previous time.but any close status then time is reset. Could you please help me with a power query logic/dax logic? Second Requirement: This is only a sample data. But we have billions of rows of data in our dataflow that comes from SQL views. So, thought not to use DAX for this calculation in future. we can precalculate the maximum open state duration by preprocessing data (SQL, Power Query(dataflow), Spark, anything else...). So can you help me prepare data upfront. we need to solve the problem with a with a proper data model. for example, create a table with the longest open events upfront (in whatever technique you are comfortable with) Could you please help me to achieve this? PFA file here B&M.pbix Thanks in advance!123Views0likes8CommentsCounting unique values in two columns
How do I count how many total unique names are associated with a unique date? See attached. I'd like to assign a number in the highlighted cell next to each name, indicating the number of unique dates beside that name. Example: The number next to Coach's name should be 4. Thank you.Solved50Views0likes3CommentsMicrosoft Places individual desk booking is not working
Hi, Following the documentation, Configure desk booking - Microsoft Places | Microsoft Learn, I successfully ran the shared command lines without any errors. However, on Microsoft Places, I am unable to see individual desks appear; only desk pools are visible. Has anyone managed to get this to work? Thanks,92Views2likes7CommentsMicrosoft 365 Family Subscription
Hi, I have an issue with my Microsoft 365 family subscription. In the past, through my employer I got a family subscription via them. As I'm no longer are working for the company, the subscription is no longer valid. We purchased a family 365 subscription via my wife and she has invited me to join the family group to my yahoo account. However, I used this yahoo email address as a backup email to my previous employer. So when I click on the invitation link, Microsoft informs me that my account is already part of a family group. When I then log on and try to leave this family group, I get an error message that I cannot. My sons email is also part of this family group and I cannot remove his account from the group either. I'd like to keep my yahoo account and not logon via another email account to join our current family subscription. Any suggestions from anyone? Thanks & Regards VEbeling06937Views0likes1CommentHow to access temp selection?
Hi, is there a way to determine the temporary selection address from vba? The steps to reproduce are as follows: Select cells [A1:A3]. Hold the right mouse button and drag the selection and move to A10, now release the right mouse button and I have a temporary drag and drop area of [A1:A10]. However it is not the current selection (the result from Application.Selection is still "A1:A3") Thanks you!Solved51Views0likes2CommentsHow to return counts of text cells across multiple worksheets in same workbook?
I'm working in Excel 365. Windows environment. Working in the Excel app but will be posting to a shared drive for multi-user data entry. 38 worksheets, one for each office. What I need is to be able to return the total # of records in the data set that are marked as 'Complete', 'Pending' and 'Urgent' (from a drop-down is one cell of each record), by office and the Rep's name that made the entry (also from drop-down). I would also like to be able to return the total entries across all worksheets by Rep Name, so I can see which offices/Reps are making the most/least entries. I'm not very savvy with using Power Query. I've tried to do it, but I think it requires that there are no blank cells in the records. It keeps making tables in the query that don't actually exist. Tried it using 6 worksheets, just to test it, and the appended data set contains way more tables that I added. I'm not bad with pivot tables. If anyone has an idea of how I could accomplish this, I sure would appreciate it! Thanks in advance for any assistance. :)39Views0likes1CommentNew formulas like FILTER and UNIQUE not appearing on macOS
Hello, I have MacBook pro with macOS Monterey 12.6.6 and I am running Excel 365 16.82. I know there is a more recent version of macOS and Excel which requires 13.0 or newer, but I don't think my version is that old that it doesn't have UNIQUE and FILTER? When I type =FILTER I get the error #NAME? and it is not suggesting any functions with similar names. Why is this the case?25Views0likes1Comment
Events
Recent Blogs
- Empowering our users to tell stories worth sharing lies at the heart of what we do at Clipchamp, and in a world increasingly focused on enterprise narratives, it’s become clear that these stories are...Feb 10, 2025396Views2likes2Comments
- We are excited to announce a series of new features in Shared Device Mode that will significantly enhance the experienceFeb 10, 2025274Views1like0Comments