Category: Microsoft
Category Archives: Microsoft
Limit sum to 100
Can anyone please help?
Working in a column 1 where applying SUMIFS formula from another sheet having 51 different values. Among those 51 values I just need to see in Column1 upto sum 100 values.
For examples 1st,2nd and 3rd value which are 50,25,25 respectively make sum of 100 which is fine
but in some case 1st,2nd and 3rd value which are 50,35,35 respectively make sum of 110 so in this case how I can restrict sum to limit upto 100 only ?
Looking for support
Thanks 🙂
Can anyone please help? Working in a column 1 where applying SUMIFS formula from another sheet having 51 different values. Among those 51 values I just need to see in Column1 upto sum 100 values. For examples 1st,2nd and 3rd value which are 50,25,25 respectively make sum of 100 which is fine but in some case 1st,2nd and 3rd value which are 50,35,35 respectively make sum of 110 so in this case how I can restrict sum to limit upto 100 only ? Looking for support Thanks 🙂 Read More
Sharepoint site feature
Does anyone know how to add a button that can float and would allow visitors to scroll to the top of the page?
Does anyone know how to add a button that can float and would allow visitors to scroll to the top of the page? Read More
SharePoint group access
we have one SharePoint group and that group admin was left from our company. Now, we need to modify that group access. we don’t have admin access to that group.How to add/modify new members in that group?
we have one SharePoint group and that group admin was left from our company. Now, we need to modify that group access. we don’t have admin access to that group.How to add/modify new members in that group? Read More
How to Fix QuickBooks Payroll Error PS038 while processing Payroll?
Troubleshooting Solutions: QuickBooks Payroll Error PS038 while processing Payroll
QuickBooks Error “PS038” during payroll processing can be resolved through several troubleshooting steps:
Update QuickBooks: Ensure QuickBooks Desktop is updated to the latest version to fix any known issues.Verify Employee Information: Check and update employee details like names, addresses, and tax information for accuracy.Check Payroll Subscription: Ensure the payroll subscription is active and up-to-date to avoid processing errors.Review Payroll Item Setup: Verify payroll item configurations to ensure correct settings for wages, taxes, and deductions.Update Tax Table: Update the payroll tax table to the latest version to ensure accurate tax calculations.Run Payroll Updates: Run the latest payroll updates within QuickBooks Desktop to apply fixes and compliance changes.Optimize Company File: Condense or optimize the company file to improve processing speed and reduce errors.Disable User Account Control (UAC): Temporarily disable User Account Control (UAC) settings to prevent interference with QuickBooks processes.Clear Temporary Files: Clear temporary files and cache within QuickBooks Desktop to resolve conflicts.Run Reboot.bat Utility: Use the reboot.bat utility to repair damaged components of QuickBooks Desktop.Seek QuickBooks Support: If the issue persists, contact QuickBooks support for advanced troubleshooting assistance.
Following these steps should help resolve QuickBooks Error PS038, ensuring smooth payroll processing without interruptions.
Troubleshooting Solutions: QuickBooks Payroll Error PS038 while processing Payroll QuickBooks Error “PS038” during payroll processing can be resolved through several troubleshooting steps: Update QuickBooks: Ensure QuickBooks Desktop is updated to the latest version to fix any known issues.Verify Employee Information: Check and update employee details like names, addresses, and tax information for accuracy.Check Payroll Subscription: Ensure the payroll subscription is active and up-to-date to avoid processing errors.Review Payroll Item Setup: Verify payroll item configurations to ensure correct settings for wages, taxes, and deductions.Update Tax Table: Update the payroll tax table to the latest version to ensure accurate tax calculations.Run Payroll Updates: Run the latest payroll updates within QuickBooks Desktop to apply fixes and compliance changes.Optimize Company File: Condense or optimize the company file to improve processing speed and reduce errors.Disable User Account Control (UAC): Temporarily disable User Account Control (UAC) settings to prevent interference with QuickBooks processes.Clear Temporary Files: Clear temporary files and cache within QuickBooks Desktop to resolve conflicts.Run Reboot.bat Utility: Use the reboot.bat utility to repair damaged components of QuickBooks Desktop.Seek QuickBooks Support: If the issue persists, contact QuickBooks support for advanced troubleshooting assistance.Following these steps should help resolve QuickBooks Error PS038, ensuring smooth payroll processing without interruptions. Read More
Save and edit without logging in
Hi guys
I have set up a Microsoft Form that will need to be filled in by 250+ people every day for 7 days. The people do not have logins and the nature of the form is that it needs to be filled out throughout the day. Is there any way for them to do this where it saves your responses?
Let me know if this is not making sense, I might not be articulating it correctly.
Hi guys I have set up a Microsoft Form that will need to be filled in by 250+ people every day for 7 days. The people do not have logins and the nature of the form is that it needs to be filled out throughout the day. Is there any way for them to do this where it saves your responses? Let me know if this is not making sense, I might not be articulating it correctly. Read More
Controlling chat with external consumer accounts, while still allowing meetings
The Teams admin centre has a switch for “People in my organization can communicate with Teams users whose accounts aren’t managed by an organization”.
I am expecting that if I disable this then my org users will no longer be able to chat with external consumer accounts like outlook, live, hotmail etc.
…but what is the implication for meetings? If I disable this setting and then try to invite a gmail or outlook consumer user to a scheduled Teams meeting… will that still work? I want to block the chat but not the scheduled meetings.
Also, I assume this does not affect chatting with consumer users (eg. gmail) who are already added as guests in a team… ? Can anyone confirm on that point? Thanks!
The Teams admin centre has a switch for “People in my organization can communicate with Teams users whose accounts aren’t managed by an organization”. I am expecting that if I disable this then my org users will no longer be able to chat with external consumer accounts like outlook, live, hotmail etc. …but what is the implication for meetings? If I disable this setting and then try to invite a gmail or outlook consumer user to a scheduled Teams meeting… will that still work? I want to block the chat but not the scheduled meetings. Also, I assume this does not affect chatting with consumer users (eg. gmail) who are already added as guests in a team… ? Can anyone confirm on that point? Thanks! Read More
How to pass AZ-900 Exam with few days prep?
DumpsSure’s thorough practice tests for the AZ-900 Exam were instrumental in my effective and confident preparation. These tests comprehensively addressed all essential topics and exam objectives, aiding me in evaluating my understanding and pinpointing areas requiring improvement. The inclusion of practical scenarios in the tests proved invaluable, enhancing my grasp of applying Azure concepts practically. Through regular practice and a thorough review of DumpsSure’s practice tests, I acquired the requisite knowledge and assurance to excel in the AZ-900 exam. I enthusiastically endorse DumpsSure’s practice tests to anyone gearing up for Azure certifications.
DumpsSure’s thorough practice tests for the AZ-900 Exam were instrumental in my effective and confident preparation. These tests comprehensively addressed all essential topics and exam objectives, aiding me in evaluating my understanding and pinpointing areas requiring improvement. The inclusion of practical scenarios in the tests proved invaluable, enhancing my grasp of applying Azure concepts practically. Through regular practice and a thorough review of DumpsSure’s practice tests, I acquired the requisite knowledge and assurance to excel in the AZ-900 exam. I enthusiastically endorse DumpsSure’s practice tests to anyone gearing up for Azure certifications. Read More
Allow open document local from Onde Drive for Business.
Hello,
What is the right settings on a shared document (from OneDrive for businnes) to allow the someone outside the orcanisation to open and edit the document in his local Office app?
Can only edit in the browser now (Ecxel)
Best regards
Geir
Hello, What is the right settings on a shared document (from OneDrive for businnes) to allow the someone outside the orcanisation to open and edit the document in his local Office app? Can only edit in the browser now (Ecxel) Best regards Geir Read More
SharePoint rest api creates list items in the folder
Hi Community,
As I was performing the operation, ‘SharePoint rest api creates list items in the folder.’.
I have used the below code:
Here, I am getting the access token error. Due to this, I can load the User data in the dropdown.
I am having difficulties performing the operation
Can anyone guide me
<script src=”https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js”></script>
<div id=”createItemDiv”>
<h2>Create Item</h2>
<label for=”title”>Title:</label><br>
<input type=”text” id=”title” name=”title” value=”Item Title”><br>
<label for=”category”>Product Category:</label><br>
<select id=”category” name=”category”>
<option value=”Books”>Books</option>
<option value=”Electronics”>Electronics</option>
<option value=”Home & Kitchen”>Home & Kitchen</option>
</select><br>
<label for=”user”>User:</label><br>
<select id=”user” name=”user”>
<!– User options will be populated dynamically –>
</select><br><br>
<button id=”createItemBtn”>Create Item</button>
</div>
<script type=”text/javascript”>
$(document).ready(function() {
var clientId = “your-client-id”;
var clientSecret = “your-client-secret”;
var resource = encodeURIComponent(“https://szg52.sharepoint.com”); // URL encode your SharePoint site URL
// Populate user dropdown
populateUsers();
// Function to populate user dropdown
function populateUsers() {
getAccessToken(function(accessToken) {
$.ajax({
url: “https://szg52.sharepoint.com/sites/Sales/_api/web/siteusers”,
type: “GET”,
headers: {
“Authorization”: “Bearer ” + accessToken,
“Accept”: “application/json;odata=nometadata”
},
success: function(data) {
$(“#user”).empty();
data.value.forEach(function(user) {
// Exclude groups and system users
if (!user.IsHiddenInUI && !user.PrincipalTypeFlags.includes(“SharePointGroup”) && !user.PrincipalTypeFlags.includes(“System”)) {
$(“#user”).append(‘<option value=”‘ + user.LoginName + ‘”>’ + user.Title + ‘</option>’);
}
});
},
error: function(error) {
console.error(“Error fetching users:”, error);
}
});
});
}
// Event listener for Create Item button
$(“#createItemBtn”).click(function(event) {
event.preventDefault(); // Prevent page refresh
// Obtain access token and then create item
getAccessToken(function(accessToken) {
var siteUrl = “https://szg52.sharepoint.com/sites/Sales”;
var listTitle = “Sales”;
var folderPath = “/User Manual”;
var title = $(“#title”).val();
var category = $(“#category”).val();
var user = $(“#user”).val();
var url = siteUrl + “/_api/web/lists/GetByTitle(‘” + listTitle + “‘)/AddValidateUpdateItemUsingPath”;
var itemData = {
“listItemCreateInfo”: {
“FolderPath”: {
“DecodedUrl”: siteUrl + “/lists/” + listTitle + folderPath
},
“UnderlyingObjectType”: 0
},
“formValues”: [
{
“FieldName”: “Title”,
“FieldValue”: title
},
{
“FieldName”: “ProductCategory”,
“FieldValue”: category
},
{
“FieldName”: “User”,
“FieldValue”: {
“Key”: user
}
}
],
“bNewDocumentUpdate”: false
};
$.ajax({
url: url,
type: “POST”,
headers: {
“Authorization”: “Bearer ” + accessToken,
“Accept”: “application/json;odata=nometadata”,
“Content-Type”: “application/json;odata=nometadata”,
“X-RequestDigest”: $(“#__REQUESTDIGEST”).val()
},
data: JSON.stringify(itemData),
success: function(data) {
console.log(“Item created successfully.”);
console.log(data);
alert(“Item created successfully.”);
},
error: function(error) {
console.log(“Error creating item:”, error);
alert(“Error creating item.”);
}
});
});
});
// Function to obtain access token
function getAccessToken(callback) {
$.ajax({
url: “https://accounts.accesscontrol.windows.net/common/tokens/OAuth/2”,
type: “POST”,
data: {
“grant_type”: “client_credentials”,
“client_id”: clientId,
“client_secret”: clientSecret,
“resource”: resource
},
success: function(response) {
var accessToken = response.access_token;
console.log(“Access Token:”, accessToken);
if (typeof callback === ‘function’) {
callback(accessToken);
}
},
error: function(error) {
console.error(“Error getting access token:”, error);
}
});
}
});
</script>
Hi Community,As I was performing the operation, ‘SharePoint rest api creates list items in the folder.’.I have used the below code:Here, I am getting the access token error. Due to this, I can load the User data in the dropdown.I am having difficulties performing the operationCan anyone guide me <script src=”https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js”></script>
<div id=”createItemDiv”>
<h2>Create Item</h2>
<label for=”title”>Title:</label><br>
<input type=”text” id=”title” name=”title” value=”Item Title”><br>
<label for=”category”>Product Category:</label><br>
<select id=”category” name=”category”>
<option value=”Books”>Books</option>
<option value=”Electronics”>Electronics</option>
<option value=”Home & Kitchen”>Home & Kitchen</option>
</select><br>
<label for=”user”>User:</label><br>
<select id=”user” name=”user”>
<!– User options will be populated dynamically –>
</select><br><br>
<button id=”createItemBtn”>Create Item</button>
</div>
<script type=”text/javascript”>
$(document).ready(function() {
var clientId = “your-client-id”;
var clientSecret = “your-client-secret”;
var resource = encodeURIComponent(“https://szg52.sharepoint.com”); // URL encode your SharePoint site URL
// Populate user dropdown
populateUsers();
// Function to populate user dropdown
function populateUsers() {
getAccessToken(function(accessToken) {
$.ajax({
url: “https://szg52.sharepoint.com/sites/Sales/_api/web/siteusers”,
type: “GET”,
headers: {
“Authorization”: “Bearer ” + accessToken,
“Accept”: “application/json;odata=nometadata”
},
success: function(data) {
$(“#user”).empty();
data.value.forEach(function(user) {
// Exclude groups and system users
if (!user.IsHiddenInUI && !user.PrincipalTypeFlags.includes(“SharePointGroup”) && !user.PrincipalTypeFlags.includes(“System”)) {
$(“#user”).append(‘<option value=”‘ + user.LoginName + ‘”>’ + user.Title + ‘</option>’);
}
});
},
error: function(error) {
console.error(“Error fetching users:”, error);
}
});
});
}
// Event listener for Create Item button
$(“#createItemBtn”).click(function(event) {
event.preventDefault(); // Prevent page refresh
// Obtain access token and then create item
getAccessToken(function(accessToken) {
var siteUrl = “https://szg52.sharepoint.com/sites/Sales”;
var listTitle = “Sales”;
var folderPath = “/User Manual”;
var title = $(“#title”).val();
var category = $(“#category”).val();
var user = $(“#user”).val();
var url = siteUrl + “/_api/web/lists/GetByTitle(‘” + listTitle + “‘)/AddValidateUpdateItemUsingPath”;
var itemData = {
“listItemCreateInfo”: {
“FolderPath”: {
“DecodedUrl”: siteUrl + “/lists/” + listTitle + folderPath
},
“UnderlyingObjectType”: 0
},
“formValues”: [
{
“FieldName”: “Title”,
“FieldValue”: title
},
{
“FieldName”: “ProductCategory”,
“FieldValue”: category
},
{
“FieldName”: “User”,
“FieldValue”: {
“Key”: user
}
}
],
“bNewDocumentUpdate”: false
};
$.ajax({
url: url,
type: “POST”,
headers: {
“Authorization”: “Bearer ” + accessToken,
“Accept”: “application/json;odata=nometadata”,
“Content-Type”: “application/json;odata=nometadata”,
“X-RequestDigest”: $(“#__REQUESTDIGEST”).val()
},
data: JSON.stringify(itemData),
success: function(data) {
console.log(“Item created successfully.”);
console.log(data);
alert(“Item created successfully.”);
},
error: function(error) {
console.log(“Error creating item:”, error);
alert(“Error creating item.”);
}
});
});
});
// Function to obtain access token
function getAccessToken(callback) {
$.ajax({
url: “https://accounts.accesscontrol.windows.net/common/tokens/OAuth/2”,
type: “POST”,
data: {
“grant_type”: “client_credentials”,
“client_id”: clientId,
“client_secret”: clientSecret,
“resource”: resource
},
success: function(response) {
var accessToken = response.access_token;
console.log(“Access Token:”, accessToken);
if (typeof callback === ‘function’) {
callback(accessToken);
}
},
error: function(error) {
console.error(“Error getting access token:”, error);
}
});
}
});
</script>@surez @CDFFAB @bessd Read More
SharePoint Online Custom Webparts
Hi All,
I’m looking for a way to export a Custom Web Part in SharePoint Online.
A old IT employee created a SharePoint Communication site with a lot of Custom Web Parts. This employee doesn’t work for the company anymore and i got the task to make some changes to the SharePoint Site/create a new site.
So i hope there is a way to export the custom webparts.
Does anyone know?
Thanks in advance
Chris
Hi All, I’m looking for a way to export a Custom Web Part in SharePoint Online.A old IT employee created a SharePoint Communication site with a lot of Custom Web Parts. This employee doesn’t work for the company anymore and i got the task to make some changes to the SharePoint Site/create a new site. So i hope there is a way to export the custom webparts.Does anyone know? Thanks in advanceChris Read More
how can i show value of one cell in another cell without writing the formula
i want to show values of cell 1 from sheet 1 in the cell 2 from sheet 2 without writing any formula in the cell 2
for example : if the g30 cell is =sum(g1:g29) and i want the value to be shown in b10 in sheet 2 , i have to write (=sheet1!g30) in cell b10 to see the value of g30 in b10 , how can see the value of g30 in b10 without writing any formula in b10.
i want to show values of cell 1 from sheet 1 in the cell 2 from sheet 2 without writing any formula in the cell 2 for example : if the g30 cell is =sum(g1:g29) and i want the value to be shown in b10 in sheet 2 , i have to write (=sheet1!g30) in cell b10 to see the value of g30 in b10 , how can see the value of g30 in b10 without writing any formula in b10. Read More
OData_ is added to columns created with underscores.
When creating a column in SharePoint with an underscore in its name, the system automatically prefixes ‘OData_’ to the column name. Why it is getting added?
When creating a column in SharePoint with an underscore in its name, the system automatically prefixes ‘OData_’ to the column name. Why it is getting added? Read More
SQL Server 2022 Replication
Is Merge Replication 2022 supported to execute stored procedue?
Is Merge Replication 2022 supported to execute stored procedue? Read More
Apple App deployment
Hi, i have Apple business manager synced with Intune for both Devices and Apps and that part is working fine. However two things
1. We are using managed apple ids, and everytime a user logs into their phone it reminds them that their managed apple ID cannot be used to purchase apps, is there a way to supress this message?
2. I am a little stuck on deploying the Company portal Intune app to these devices. It appears its as simple as assigning the Company portal Intune VPP App to a device group as required intune. problem is we have a tenant owned by our parent company that is shared by multiple child companies like ours, so i need to ensure i only assign to our iphones, do you think it’s possible to use profile name i have assigned to create the dynamic device group based on say device.enrollmentProfileName -eq “mycompany iOS/iPadOS Profile” ? i have to wait for my parent comany admins to create the group and they can take a while to respond so just making sure this will work?
Thanks for any assistance.
Hi, i have Apple business manager synced with Intune for both Devices and Apps and that part is working fine. However two things 1. We are using managed apple ids, and everytime a user logs into their phone it reminds them that their managed apple ID cannot be used to purchase apps, is there a way to supress this message? 2. I am a little stuck on deploying the Company portal Intune app to these devices. It appears its as simple as assigning the Company portal Intune VPP App to a device group as required intune. problem is we have a tenant owned by our parent company that is shared by multiple child companies like ours, so i need to ensure i only assign to our iphones, do you think it’s possible to use profile name i have assigned to create the dynamic device group based on say device.enrollmentProfileName -eq “mycompany iOS/iPadOS Profile” ? i have to wait for my parent comany admins to create the group and they can take a while to respond so just making sure this will work? Thanks for any assistance. Read More
How to avoid SP List content access to Site collection admins?
My client requests to ensure that only authorized users have access to site list content (such as task lists, document library, etc). Since I am Site collection administrator I have access to all data even if I do not show in permission list. How can I make a 100% sure that content is only available to client? How can I ensure that only he is able to change permission so nobody of my admin team can ever change anything in order to get access to the particular list?
My client requests to ensure that only authorized users have access to site list content (such as task lists, document library, etc). Since I am Site collection administrator I have access to all data even if I do not show in permission list. How can I make a 100% sure that content is only available to client? How can I ensure that only he is able to change permission so nobody of my admin team can ever change anything in order to get access to the particular list? Read More
Teams Meet Now Feature Gets a Makeover for Group Chats
Teams group chats are getting a new Meet Now experience. Is that good news? Well, it’s not an earthshattering change, but it is a nice change because it simplifies the way the Meet Now feature works. It’s the kind of change that software vendors make to tidy up the loose ends in a product.
https://office365itpros.com/2024/04/25/meet-now-teams/
Teams group chats are getting a new Meet Now experience. Is that good news? Well, it’s not an earthshattering change, but it is a nice change because it simplifies the way the Meet Now feature works. It’s the kind of change that software vendors make to tidy up the loose ends in a product.
https://office365itpros.com/2024/04/25/meet-now-teams/ Read More
Hide copilot icon in Word 365
I would like to hide/disable the copilot icon that automatically appears on Word 365 pages as I write. I *do not* want to disable copilot. Just the icon – it is intrusive and irritating.
To be clear: I have the copilot button on my ribbon – that is *not* the issue. The issue is the icon on the page I am working on.
this should be easy but I have spent an hour to no avail…
Don
I would like to hide/disable the copilot icon that automatically appears on Word 365 pages as I write. I *do not* want to disable copilot. Just the icon – it is intrusive and irritating. To be clear: I have the copilot button on my ribbon – that is *not* the issue. The issue is the icon on the page I am working on. this should be easy but I have spent an hour to no avail… Don Read More
SQLserver 2019 filestream share not visible, although no errors
Hello (first time post in sqlserver section):
Out developers have a problem regarding filestream feature in sqlserver 2019. We activated the feature with I/O Fileaccess. Then “EXEC sp_configure filestream_access_level, 2; RECONFIGURE;” then restarted the service, and started the Clustergroup. We activated fullaccess in SQLmanager and the the sharename was blank! We restarted the server , switched the nodes and back. Still blank and also not showing any fileshare with UNC. (The name of the share is “MSSQLSERVER”, fyi.)
In powershell or in the Failover-clustermanager the “other ressource”, the ” SQL Server FILESTREAM share (MSSQLSERVER)” is online and there, with the running property of 2. Server is uptodate.
The powershell showed me type “fileshare” and not of type “SQL Server FILESTREAM Share” (which i don’t know its normal or not).
And the only error i saw is when i go on the “share” tab in the failover-clustermanager, open the properties of this filestream share and i get an error like:
” the information for the share cannot be loaded” (translated from german).
Which can explain that i don’t see the sharename in managementstudio nor in the windows Shares in controlpanel, which i think is a problem on the failoverside and not on the sqlserver side.
But How i can debug or fix it?
Hello (first time post in sqlserver section): Out developers have a problem regarding filestream feature in sqlserver 2019. We activated the feature with I/O Fileaccess. Then “EXEC sp_configure filestream_access_level, 2; RECONFIGURE;” then restarted the service, and started the Clustergroup. We activated fullaccess in SQLmanager and the the sharename was blank! We restarted the server , switched the nodes and back. Still blank and also not showing any fileshare with UNC. (The name of the share is “MSSQLSERVER”, fyi.) In powershell or in the Failover-clustermanager the “other ressource”, the ” SQL Server FILESTREAM share (MSSQLSERVER)” is online and there, with the running property of 2. Server is uptodate.The powershell showed me type “fileshare” and not of type “SQL Server FILESTREAM Share” (which i don’t know its normal or not).And the only error i saw is when i go on the “share” tab in the failover-clustermanager, open the properties of this filestream share and i get an error like:” the information for the share cannot be loaded” (translated from german).Which can explain that i don’t see the sharename in managementstudio nor in the windows Shares in controlpanel, which i think is a problem on the failoverside and not on the sqlserver side. But How i can debug or fix it? Read More
Microsoft copilot
Tenho dificuldade em implementar microsoft Copilot no Office 365
Tenho dificuldade em implementar microsoft Copilot no Office 365 Read More
Countries disappear from map.
Hello everyone!
I am having trouble with my Excel map, as some countries straight up do not show when entering data, as follows :
I have tried rebooting the computer and using countries in other languages. It did work before, this issue only appeared recently.
Has anyone else encountered this issue and/or know a fix? I have a hunch that it has something to do with the Internet, not my program.
Thank you!
Hello everyone! I am having trouble with my Excel map, as some countries straight up do not show when entering data, as follows : I have tried rebooting the computer and using countries in other languages. It did work before, this issue only appeared recently. Has anyone else encountered this issue and/or know a fix? I have a hunch that it has something to do with the Internet, not my program. Thank you! Read More