Tag Archives: microsoft
Dynamic Filtering lists – Slow page responses
Has anyone else experienced slow page responses when using the dynamic filtering of two lists? I’m doing this on a modern SharePoint Online page and it is a very slow response. This is an old feature (was available in SharePoint On-prem 2013, so not sure why it is so slow. Any suggestions?
Has anyone else experienced slow page responses when using the dynamic filtering of two lists? I’m doing this on a modern SharePoint Online page and it is a very slow response. This is an old feature (was available in SharePoint On-prem 2013, so not sure why it is so slow. Any suggestions? Read More
How to fix Payroll Error Code 40003 QuickBooks Desktop Windows 10?
I encountered Payroll Error Code 40003 on QuickBooks Desktop Windows 10 while processing payroll. Each attempt to resolve it proves unsuccessful. Seeking expert assistance to troubleshoot and resolve this issue promptly.
I encountered Payroll Error Code 40003 on QuickBooks Desktop Windows 10 while processing payroll. Each attempt to resolve it proves unsuccessful. Seeking expert assistance to troubleshoot and resolve this issue promptly. Read More
Data Entry Mode to Edit Mode(?)
We are currently having a database built for our company. When selecting a Form, it opens on a Blank Record, however, when we search for a record and select it, it will open the first record we ever entered into the database and then populate the record we are searching for. Is there a work around for this? We are told it is going from Data Entry mode, to edit mode and that is what is causing the temp record to populate. It is better to be shown in video than a picture, but I have uploaded a picture.
We are currently having a database built for our company. When selecting a Form, it opens on a Blank Record, however, when we search for a record and select it, it will open the first record we ever entered into the database and then populate the record we are searching for. Is there a work around for this? We are told it is going from Data Entry mode, to edit mode and that is what is causing the temp record to populate. It is better to be shown in video than a picture, but I have uploaded a picture. Read More
Re: Attrition Rate calculation in Excel
Hello! You’ve posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I’m moving your question to the Excel space – please post Excel questions here in the future.
@Vinod_Sir
Hello! You’ve posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I’m moving your question to the Excel space – please post Excel questions here in the future. Read More
Copilot on premise
I promise I searched this community before asking this question 🙂
Is there a way to grant copilot access to on-premise file share data to form it’s model in order to ask questions/prompt? Copilot seems powerful when used against M365 account/Azure tenant data. Is there a way to include on-premise data in this model?
I promise I searched this community before asking this question 🙂 Is there a way to grant copilot access to on-premise file share data to form it’s model in order to ask questions/prompt? Copilot seems powerful when used against M365 account/Azure tenant data. Is there a way to include on-premise data in this model? Read More
Need help setting print areas
I’m use Excel for Mac and recently my worksheets are not staying at one page when I select “fit to page”.
I larger spreadsheets and I can get the width to fit to the page by going to Page Layout –> Width –> 1 Page, but if I put the height to 1 Page instead of Automatic then it shrinks the entire spreadsheet to a small corner of the page. I can’t figure out why there are so many extra lines at the bottom of the spreadsheet, its blank and there’s no data. If I try to print or save as PDF, it will have an extra 3 – 4 blank pages at the bottom.
Can anyone help?
I’m use Excel for Mac and recently my worksheets are not staying at one page when I select “fit to page”. I larger spreadsheets and I can get the width to fit to the page by going to Page Layout –> Width –> 1 Page, but if I put the height to 1 Page instead of Automatic then it shrinks the entire spreadsheet to a small corner of the page. I can’t figure out why there are so many extra lines at the bottom of the spreadsheet, its blank and there’s no data. If I try to print or save as PDF, it will have an extra 3 – 4 blank pages at the bottom. Can anyone help? Read More
Auto Classify Power BI Reports
Hello,
Is there a way to automatically classify Power BI reports with scans? I have been testing and reviewing documentation but I can’t find anything. Thank you.
Hello, Is there a way to automatically classify Power BI reports with scans? I have been testing and reviewing documentation but I can’t find anything. Thank you. Read More
Assigned staff member not showing in confirmation email
I’ve seen many, many complaints about this but no response/resolution being posted.
The staff member assigned to an appointment no longer shows in the confirmation emails. How do we fix this? Customers need to know who they are assigned to.
I’ve seen many, many complaints about this but no response/resolution being posted. The staff member assigned to an appointment no longer shows in the confirmation emails. How do we fix this? Customers need to know who they are assigned to. Read More
Average a set of values based on date
So I am trying to average a set of values that we record each day, then drop them into a different sheet. I want to do this for every day of the year, but when I pull the formula down in the table, it only moves my set of numbers being average down 1 spot instead of 6 like I want. I have attached two pictures of the example data that I want to average as well as the picture of the final results that I want out of it. What I am confused is how to get the next set of averages to populate on the right date without having to do it manually for the entire year.
Data Set 1: 3/31/24
Data Set 2: 4/1/24
End Result average compilation:
So I am trying to average a set of values that we record each day, then drop them into a different sheet. I want to do this for every day of the year, but when I pull the formula down in the table, it only moves my set of numbers being average down 1 spot instead of 6 like I want. I have attached two pictures of the example data that I want to average as well as the picture of the final results that I want out of it. What I am confused is how to get the next set of averages to populate on the right date without having to do it manually for the entire year.Data Set 1: 3/31/24Data Set 2: 4/1/24End Result average compilation: Read More
azure automation hybrid worker platform best practice
Hi
We’re moving services around and checking that some of your architecture is according to best practices.
What is the recommendations on where to install Azure automation hybrid worker?
Can we install on an AD server?
AD Sync Server?
Dedicated server?
Kind Regards
HiWe’re moving services around and checking that some of your architecture is according to best practices.What is the recommendations on where to install Azure automation hybrid worker?Can we install on an AD server? AD Sync Server?Dedicated server?Kind Regards Read More
Conditional Formatting a Table
I am new to this so bare with me.
I am creating a schedule for 5 people. There are two columns and 8 rows. The column on the left has a dropdown menu with options 1-8 representing hours. There is also another cell containing a dropdown menu with the names of the 5 people who will be scheduling. The goals are as follows:
A row will automatically shade as the number of hours are choses. For example, if in the first row “1 hour” is chosen by “Dale”, the row will be shaded the color assigned to Dale. If 2 hours, 2 rows, etc. After 8 rows is shaded, the entire table is full.
currently, the rows are correctly shading with the selected number of hours and in the in the correct colors.
Here are the problems:
1. When another name is chosen from the drop-down menu, the rows that are already shaded automatically change to the color of the new user. They need to stay the original color and be locked for changes.
2. Number of hours can manually be entered ending up at more than 8 hours per day. Is there a way to limit input to the drop down only, no manual entry?
3. When I go back in to conditional formatting, the formulas are different. Is there something I am doing wrong? A way to prevent this from happening?
Conditional Formatting rules entered in each row for each user.
Row 1 =AND($A$2=”DAVE”, C5>=1) ….
Row 2 =AND($A$2=”DAVE”, C5+C6>=2) ….
Row 3 =AND($A$2=”DAVE”, C5+C6+C7>=3) ….
Any help is appreciated.
I am new to this so bare with me. I am creating a schedule for 5 people. There are two columns and 8 rows. The column on the left has a dropdown menu with options 1-8 representing hours. There is also another cell containing a dropdown menu with the names of the 5 people who will be scheduling. The goals are as follows: A row will automatically shade as the number of hours are choses. For example, if in the first row “1 hour” is chosen by “Dale”, the row will be shaded the color assigned to Dale. If 2 hours, 2 rows, etc. After 8 rows is shaded, the entire table is full. currently, the rows are correctly shading with the selected number of hours and in the in the correct colors. Here are the problems:1. When another name is chosen from the drop-down menu, the rows that are already shaded automatically change to the color of the new user. They need to stay the original color and be locked for changes. 2. Number of hours can manually be entered ending up at more than 8 hours per day. Is there a way to limit input to the drop down only, no manual entry?3. When I go back in to conditional formatting, the formulas are different. Is there something I am doing wrong? A way to prevent this from happening? Conditional Formatting rules entered in each row for each user. Row 1 =AND($A$2=”DAVE”, C5>=1) ….Row 2 =AND($A$2=”DAVE”, C5+C6>=2) ….Row 3 =AND($A$2=”DAVE”, C5+C6+C7>=3) …. Any help is appreciated. Read More
External email senders appear in DLP Activity Explorer
Why would I be seeing ingress DLP incidents and not solely egress? Does anyone else see this activity? I have triple checked all of my policies and they are all set to: Content is shared from Microsoft 365 with people outside my organization.
I’m going crazy, any guidance would help!
ty
Why would I be seeing ingress DLP incidents and not solely egress? Does anyone else see this activity? I have triple checked all of my policies and they are all set to: Content is shared from Microsoft 365 with people outside my organization. I’m going crazy, any guidance would help!ty Read More
Linked Cells between sheets not crossing over properly
I have two workbooks with linked cells that have been saved numerous times for over a year without problem. Today I open up my one sheet and there are a lot of #NAME? errors for some of those linked cells. The formulas for those particular cells all look similar to the one below. Where the word “Rent” is there should be a cell number so that the value of that cell shows up. The only way it’s allowing me to edit correctly is to manually change every single one.
The only way I’ve ever linked these is by inputting = then double clicking on the appropriate cell and the value shows up and the sheets are linked. I cannot do that anymore. The “formula” always pops up with a word in it (related to the horizontal line but not exactly the same) not the cell number.
I’ve now spent 3 hours working with online support to be told that my content is the problem and now I must manually enter all of these values. I don’t believe this as my content didn’t change and other values on the same sheets were linked the exact same way without problem.
I’m not a computer person, I’m learning. I’m a hairstylist just trying to keep my bookkeeping up. Please, any response needs to be as if you’re speaking with a 5 year old as I do not understand tech well at all.
='[Budget 2024 .xlsx]January’!Rent should be ='[Budget 2024 .xlsx]January’!$h$86
I have two workbooks with linked cells that have been saved numerous times for over a year without problem. Today I open up my one sheet and there are a lot of #NAME? errors for some of those linked cells. The formulas for those particular cells all look similar to the one below. Where the word “Rent” is there should be a cell number so that the value of that cell shows up. The only way it’s allowing me to edit correctly is to manually change every single one. The only way I’ve ever linked these is by inputting = then double clicking on the appropriate cell and the value shows up and the sheets are linked. I cannot do that anymore. The “formula” always pops up with a word in it (related to the horizontal line but not exactly the same) not the cell number. I’ve now spent 3 hours working with online support to be told that my content is the problem and now I must manually enter all of these values. I don’t believe this as my content didn’t change and other values on the same sheets were linked the exact same way without problem. I’m not a computer person, I’m learning. I’m a hairstylist just trying to keep my bookkeeping up. Please, any response needs to be as if you’re speaking with a 5 year old as I do not understand tech well at all. ='[Budget 2024 .xlsx]January’!Rent should be ='[Budget 2024 .xlsx]January’!$h$86 Read More
Run batch job on remote VM from Azure Data Factory
Hello,
I am new to Azure and work in an environment that is mixed Azure and on-prem.
I do not have access to alter firewall rules.
I do have Managed virtual networks set up for at least 1 Azure item.
I have an on prem REST application.
I have an Azure VM that is able to access REST on its vnet.
I have an Azure ADF instance on a vnet that can contact the VM but not the REST application.
I want to pipe ADF through the VM to obtain the data. I don’t even know if this is a thing.
Anyone with experience on this can outline what I should be trying to do?
thank you!
Hello, I am new to Azure and work in an environment that is mixed Azure and on-prem.I do not have access to alter firewall rules. I do have Managed virtual networks set up for at least 1 Azure item. I have an on prem REST application.I have an Azure VM that is able to access REST on its vnet.I have an Azure ADF instance on a vnet that can contact the VM but not the REST application. I want to pipe ADF through the VM to obtain the data. I don’t even know if this is a thing.Anyone with experience on this can outline what I should be trying to do? thank you! Read More
Attrition Rate calculation in Excel
To calculate Attrition in every MNC company they use formulas as below ( sharing own industry experience across wide range of community)
MTD – Total Nos of attrition/ Total Nos of Head count
YTD – total attrition from starting month to end month / average HC of starting month to end month
Don’t forget in headcount calculation we will also consider headcount attrited as a total calculation
To calculate Attrition in every MNC company they use formulas as below ( sharing own industry experience across wide range of community)MTD – Total Nos of attrition/ Total Nos of Head countYTD – total attrition from starting month to end month / average HC of starting month to end month Don’t forget in headcount calculation we will also consider headcount attrited as a total calculation Read More
GCCH Monthly M365 Webinar: New Teams Updates and Cross-Cloud Collaboration Envisioning
We’re looking forward to our next GCCH M365 Webinar on Tuesday, April 30, at 1200 EDT. It’s the Dave show as we’ll be joined by both Dave Jennings (new Teams) and Dave Nobles (empowering secure and effective collaboration between GCCH and DoD). To receive a calendar invite, please register here.
In addition, please find attached a roll up of April M365 roadmap highlights. Happy to field any questions with what is included.
Microsoft Tech Community – Latest Blogs –Read More
Sharing Recorded Teams session when external sharing is restricted
Hi all,
I have a question about recorded sessions from TEAMs
As part of our company policy, I had to restrict sharepoint external sharing only to a ppl that are part of a security group (in SharePoint admin -> Policies -> Sharing -> ). This however looks like has an impact on TEAMS recordings and external users invited to these meetings do not have access to recordings.
The recording is usually saved to OneDrive, so I guess the SharePoint external share restriction applies to OneDrive as well? If this is the root case of preventing external users to access recordings, what options are available?
Or is there a way to have this restrictions for SharePoint but not for OneDrive?
Hi all, I have a question about recorded sessions from TEAMs As part of our company policy, I had to restrict sharepoint external sharing only to a ppl that are part of a security group (in SharePoint admin -> Policies -> Sharing -> ). This however looks like has an impact on TEAMS recordings and external users invited to these meetings do not have access to recordings. The recording is usually saved to OneDrive, so I guess the SharePoint external share restriction applies to OneDrive as well? If this is the root case of preventing external users to access recordings, what options are available? Or is there a way to have this restrictions for SharePoint but not for OneDrive? Read More
How to stop “Convert to Stocks” popup
I am trying to use excel to create a spreadsheet of products. One column has an abbreviation for the product family. These are 3 letter uppercase. For the first time Excel keeps popping up a prompt to convert to stocks. The prompt blocks the data in the adjacent field. I have tried every option suggested on the web for disabling this and none of them work. This flaw is making excel unusable. Any advice?
I am trying to use excel to create a spreadsheet of products. One column has an abbreviation for the product family. These are 3 letter uppercase. For the first time Excel keeps popping up a prompt to convert to stocks. The prompt blocks the data in the adjacent field. I have tried every option suggested on the web for disabling this and none of them work. This flaw is making excel unusable. Any advice? Read More
MS 203 Microsoft 365 Certified: Messaging Administrator Associate has been retired
what is MS 203 (Microsoft 365 Certified: Messaging Administrator Associate) replacement. what is the roadmap for exchange server and exhangeonline? if anyone knew so please guide me.
what is MS 203 (Microsoft 365 Certified: Messaging Administrator Associate) replacement. what is the roadmap for exchange server and exhangeonline? if anyone knew so please guide me. Read More
How do I make my power query automation more dynamic?
I have created an automation using power query where it’ll fetch data from a workbook called “Data”. I have manipulated the data to achieve my desired table format. The table’s final columns are: Vendor Name, Contract #, and (after pivoting the columns) the Total Amount Outstanding for the years 2019-2024 (6 separate columns). The problem I am running into is that some of my input, “Data”, workbooks only have years 2019-2023 while some have years 2020-2024. Since the initial data file I constructed my table around contained the years 2019-2024, any file I load into the table that does not include the same years reports an error message saying something like: “The column 2024 of the table was not found”. I know these sorts of things work great with standardized datasets but in this case, my years will fluctuate by one or two. How can I make my table more dynamic so that regardless of whether the file contains the same years (2019-2024) or different (i.e., 2019-2023, 2020-2024, etc…) it will still read it in and perform my desired formatting without any error messages?
I have created an automation using power query where it’ll fetch data from a workbook called “Data”. I have manipulated the data to achieve my desired table format. The table’s final columns are: Vendor Name, Contract #, and (after pivoting the columns) the Total Amount Outstanding for the years 2019-2024 (6 separate columns). The problem I am running into is that some of my input, “Data”, workbooks only have years 2019-2023 while some have years 2020-2024. Since the initial data file I constructed my table around contained the years 2019-2024, any file I load into the table that does not include the same years reports an error message saying something like: “The column 2024 of the table was not found”. I know these sorts of things work great with standardized datasets but in this case, my years will fluctuate by one or two. How can I make my table more dynamic so that regardless of whether the file contains the same years (2019-2024) or different (i.e., 2019-2023, 2020-2024, etc…) it will still read it in and perform my desired formatting without any error messages? Read More