Tag Archives: microsoft
Vlookup, Index, Match
Excel idiot here…..
In the pic below, on the sheet on the right, I am choosing two values in columns E and F from validation (reference the sheet on the left) and would like to return a value from a sheet on the left. i.e. If I choose “ELDC” and “OT Rate” on the right, I would like choose the proper value from the table on the left…in this case $31.76. Any help is appreciated!!!
Excel idiot here…..In the pic below, on the sheet on the right, I am choosing two values in columns E and F from validation (reference the sheet on the left) and would like to return a value from a sheet on the left. i.e. If I choose “ELDC” and “OT Rate” on the right, I would like choose the proper value from the table on the left…in this case $31.76. Any help is appreciated!!! Read More
Is it possible to cleanly decommission Windows CA?
So, I have a pain point I am currently dealing with. I joined the company I am with after the AD environment had already been established. There was a fair amount of turnover before I joined and part of that was that the previous System Admins were not thorough with documentation and they did things on a whim. To that, when I joined the PDC was also a CA that, as far as I could tell, was not actively being used by any systems other than the DCs to issue certs. The running theory is that the previous system admins were planning to use CA to do 802.1x type security for Wifi and VPN but never got around to completing the setup.
Obviously, it was not great that they installed the CA role onto the PDC. But I have since corrected that. I was able to extract the CA role and migrate it to a different server and I can see that it is able to issues certs to the DCs. (Looks like it has only issued Kerberos Authentication, DC Authentication, and Directory Email Replication certs since being migrated, and only on DCs). However, I don’t want the CA role around at all because it is one more server we have to maintain and we are not using it in any meaningful way.
I know there is documentation on how to actually decommission a CA from the network (How to decommission a Windows enterprise certification authority and remove all related objects ) but my question is; should/can I decommission it? Throughout my career, every time I have talked to another System Admin or gone through any training, I have always heard that I need to be extremely careful when deciding to add a CA role to a windows network. Because once it is established and issuing certs, it becomes next to impossible to fully/safely remove. Is that the case? Has anyone successfully removed a CA from their windows domain without breaking everything?
So, I have a pain point I am currently dealing with. I joined the company I am with after the AD environment had already been established. There was a fair amount of turnover before I joined and part of that was that the previous System Admins were not thorough with documentation and they did things on a whim. To that, when I joined the PDC was also a CA that, as far as I could tell, was not actively being used by any systems other than the DCs to issue certs. The running theory is that the previous system admins were planning to use CA to do 802.1x type security for Wifi and VPN but never got around to completing the setup. Obviously, it was not great that they installed the CA role onto the PDC. But I have since corrected that. I was able to extract the CA role and migrate it to a different server and I can see that it is able to issues certs to the DCs. (Looks like it has only issued Kerberos Authentication, DC Authentication, and Directory Email Replication certs since being migrated, and only on DCs). However, I don’t want the CA role around at all because it is one more server we have to maintain and we are not using it in any meaningful way. I know there is documentation on how to actually decommission a CA from the network (How to decommission a Windows enterprise certification authority and remove all related objects ) but my question is; should/can I decommission it? Throughout my career, every time I have talked to another System Admin or gone through any training, I have always heard that I need to be extremely careful when deciding to add a CA role to a windows network. Because once it is established and issuing certs, it becomes next to impossible to fully/safely remove. Is that the case? Has anyone successfully removed a CA from their windows domain without breaking everything? Read More
Need Ability to Force Native Resolution on Remote Desktop HTML5 Web Client
Hello,
Not sure if this forum is also for the HTML 5 RD web client but if so, I’d like to request a feature or ask if there’s a way to force the clients to use native resolution. We can force it to use web (vs .RDP) and suppress telemetry but not the native resolution slider. I tried a few DWORDS in HKLMSoftwareMicrosoftRemoteDesktopWeb but no luck.
When we roll this out to hundreds of users, they’ll all have to check that box. Would be nice if we could force it on the admin side with a reg key or the Set-RDWebClientDeploymentSetting cmdlet.
thanks,
Dan
Hello, Not sure if this forum is also for the HTML 5 RD web client but if so, I’d like to request a feature or ask if there’s a way to force the clients to use native resolution. We can force it to use web (vs .RDP) and suppress telemetry but not the native resolution slider. I tried a few DWORDS in HKLMSoftwareMicrosoftRemoteDesktopWeb but no luck. When we roll this out to hundreds of users, they’ll all have to check that box. Would be nice if we could force it on the admin side with a reg key or the Set-RDWebClientDeploymentSetting cmdlet. thanks,Dan Read More
Formula trouble
I want to do this thing, but I have no idea where to start or what type of formulas to try:
I’m tracking evaluations in my company
Column E is the type of evaluation: Initial F, and Initial E.
Column G is the date their evaluation process was initiated
Column H is the date their evaluation process closes out.
People designated “Initial F” in column E have a close out date (Column H) that is 60 days after their initiation date (Column G)
People designated “Initial E” in column E have a close out date (Column H) that is 45 days after their initiation date (Column G)
I want column H to automatically generate a date that is respectively, 45 or 60 days after the date in column G based on the condition in column E.
I want to do this thing, but I have no idea where to start or what type of formulas to try:I’m tracking evaluations in my company Column E is the type of evaluation: Initial F, and Initial E. Column G is the date their evaluation process was initiatedColumn H is the date their evaluation process closes out. People designated “Initial F” in column E have a close out date (Column H) that is 60 days after their initiation date (Column G)People designated “Initial E” in column E have a close out date (Column H) that is 45 days after their initiation date (Column G) I want column H to automatically generate a date that is respectively, 45 or 60 days after the date in column G based on the condition in column E. Read More
Bookings Emails Deleting automatically
I am an IT admin for Bookings at our organization. One of our staff members noticed her Bookings meeting confirmations are automatically directed to her trash. I assume this is because the meeting invite is accepted automatically on her behalf. Unfortunately, pertinent information is on those emails (such as notes and customer responses). We have tried to make mailbox rules as well as toggle “ignored” emails off but to no avail. Please advise.
I am an IT admin for Bookings at our organization. One of our staff members noticed her Bookings meeting confirmations are automatically directed to her trash. I assume this is because the meeting invite is accepted automatically on her behalf. Unfortunately, pertinent information is on those emails (such as notes and customer responses). We have tried to make mailbox rules as well as toggle “ignored” emails off but to no avail. Please advise. Read More
Formula to autofill a PO #
I have a workbook with 2 sheets.
Sheet 1, column A is where the formula needs to go – based off the information in the sheet called Customer list.
Example: Customer List – Column A is customer name – Column B is the PO# Starting String. This is specific to the customer.
I want to open Sheet 1 and type a customer name in B2 and a PO number automatically fill in based off the criteria mentioned above. So if my Customer name is Asset Living (on sheet: Customer List – A2) and I type Asset Living in Sheet 1, B2, the the PO# that populates in Sheet 1 A2 should be AL(from Customer List, B2) followed by random numbers (preferrably 3 digits).
I have a workbook with 2 sheets.Sheet 1, column A is where the formula needs to go – based off the information in the sheet called Customer list.Example: Customer List – Column A is customer name – Column B is the PO# Starting String. This is specific to the customer.I want to open Sheet 1 and type a customer name in B2 and a PO number automatically fill in based off the criteria mentioned above. So if my Customer name is Asset Living (on sheet: Customer List – A2) and I type Asset Living in Sheet 1, B2, the the PO# that populates in Sheet 1 A2 should be AL(from Customer List, B2) followed by random numbers (preferrably 3 digits). Read More
xlookup with table issue
Hello!
I am working on a file that requires use of xlookup. to keep things organized and for ease of reviewal, i use the table headers in the formulas (instead of just column letter). I realized that my formulas are not working properly. when I set the formula up, it only seems to return the value that appears first in the lookup array.
For example, I am trying to find and return three different things: call them A, B, and C. In the table that I am doing the lookup from, if A, B, and C are listed in that order, then my lookups will only have one that works, and it will return A. During trouble shooting, I deleted the rows that had A and B, leaving only C. Once I did this, the C was the first lookup value in the lookup table, and the formula worked (it returned C). This informs me that it is not an error of difference of spelling / spaces / etc. in lookup value and items in lookup array.
Also during troubleshooting, I used the column letters as opposed to the table header names in the formula, and it worked perfect.
Has anyone experienced this before / does anyone have any tips???
Hello! I am working on a file that requires use of xlookup. to keep things organized and for ease of reviewal, i use the table headers in the formulas (instead of just column letter). I realized that my formulas are not working properly. when I set the formula up, it only seems to return the value that appears first in the lookup array. For example, I am trying to find and return three different things: call them A, B, and C. In the table that I am doing the lookup from, if A, B, and C are listed in that order, then my lookups will only have one that works, and it will return A. During trouble shooting, I deleted the rows that had A and B, leaving only C. Once I did this, the C was the first lookup value in the lookup table, and the formula worked (it returned C). This informs me that it is not an error of difference of spelling / spaces / etc. in lookup value and items in lookup array. Also during troubleshooting, I used the column letters as opposed to the table header names in the formula, and it worked perfect. Has anyone experienced this before / does anyone have any tips??? Read More
Drive Encryption through Endpoint Security no longer showing option to backup information in Entra
Hi All – Just want to check with Community members if others are seeing similar while configuring Drive Encryption under Endpoint Security in Intune. Can see option to save BitLocker recovery information in AD DS but not in Microsoft Entra ID. Is this a bug?
Hi All – Just want to check with Community members if others are seeing similar while configuring Drive Encryption under Endpoint Security in Intune. Can see option to save BitLocker recovery information in AD DS but not in Microsoft Entra ID. Is this a bug? Read More
Improve your forms with Copilot suggestions
Copilot has always been helpful at crafting forms and fine-tuning questions. Now, it also serves as an intelligent assistant throughout your journey, offering additional smart suggestions. By using these tips, you can make your form/quiz more attractive and easier to complete, leading to better results with less effort. Let’s check it now!
How to activate
For any newly created or existing forms/quizzes, a banner at the top will remind you that Copilot has suggestions for you. You can just click ‘View’ to check the details.
Theme suggestion
Responder’s first impression of your form is crucial, and a visually appealing design can certainly capture their attention. Copilot will start by offering several theme options based on your topic, helping you choose a look that grabs their interest.
Setting suggestion
Based on your content, Copilot will suggest settings to make your form more effective. For example, it might remind you to allow responders to save and edit their responses for more accurate feedback or set a timer for improved time management.
Distribution suggestion
Additionally, Copilot will guide you through sending out your form to help you gather more responses. Without needing to open ‘Collect Responses,’ Copilot will draft a personalized message to boost responses and help set the appropriate permissions. You only need to enter the responders’ details and send out the form.
Copilot in Forms assistant will start rolling out to commercial users (including Enterprise, SMB and EDU) in late July 2024. A Copilot for Microsoft 365 license is required to access Copilot in Forms. Discover more about Copilot for Microsoft 365 here.
Microsoft Tech Community – Latest Blogs –Read More
Deleted Teams App still being looked for on startup
Hi Everyone, we have a puzzling one, we published and subsequently deleted an App from our Teams portal. all users now get a message saying that the app can’t be found and we’re struggling with how to remedy this. The app is 100% gone from the portal. we have tried uninstall and reinstall of teams including deleting the cache, but this has not helped at all. Has anyone any idea of where to look to resolve this one – I think there’s something somewhere in the teams portal but can’t fine anything.
Kind Regards
Pete
Hi Everyone, we have a puzzling one, we published and subsequently deleted an App from our Teams portal. all users now get a message saying that the app can’t be found and we’re struggling with how to remedy this. The app is 100% gone from the portal. we have tried uninstall and reinstall of teams including deleting the cache, but this has not helped at all. Has anyone any idea of where to look to resolve this one – I think there’s something somewhere in the teams portal but can’t fine anything. Kind Regards Pete Read More
Public preview checkbox keeps unchecking
Hi 🙂
When I tick the ‘Public preview’ box within settings, it is not clear if this instantly changes to the preview version or if it needs a restart. In Classic Teams, enabling public preview used to relaunch the app.
In addition, the checkbox also regularly shows as unticked. I suspect this is happening after Teams updates (which it does a few times a day sometimes).
Does anyone else notice this? I would like to stay in preview mode the majority of the time, but at the least until I choose to turn it off. With this current way of working I am often taken out of it without being notified.
Thanks,
Ian
Hi :)When I tick the ‘Public preview’ box within settings, it is not clear if this instantly changes to the preview version or if it needs a restart. In Classic Teams, enabling public preview used to relaunch the app. In addition, the checkbox also regularly shows as unticked. I suspect this is happening after Teams updates (which it does a few times a day sometimes). Does anyone else notice this? I would like to stay in preview mode the majority of the time, but at the least until I choose to turn it off. With this current way of working I am often taken out of it without being notified. Thanks,Ian Read More
Azure Devops Teams Notification
Hello Team,
I have recently added Azure Repo app to my dev release channel. I configured “@Azure Repos subscriptions” and added notification for when a Pull Request is created. Is there a way I can exclude draft Pull Requests from sending notifications?
Hello Team, I have recently added Azure Repo app to my dev release channel. I configured “@Azure Repos subscriptions” and added notification for when a Pull Request is created. Is there a way I can exclude draft Pull Requests from sending notifications? Read More
ADODB performance problem
Hi All, (Win10, Win11)
To highlight a performance problem (with ADODB/ACCESS), on a heavy client, I wrote two small programs one in VB.NET (and VBA), the other in CPP/MFC. Using the same component (msado15.dll).
This piece of code does nothing but connect to two ACCESS files (with a single table of 15,000 records), and via a recordset copy from one database to the other.
Under VB.NET, it takes 1 second.
Under CPP, on a machine that has the runtime access 2013 x64, it takes 9 seconds. (i spend 99% of my time in AddNew() )…
Under CPP, on a machine that has the runtime access 2016 x64 OR Office365, it takes 20 minutes. (i spend 99% of my time in AddNew() )…
The target computer must have Office365…
I need an issue…
PS : My two sln (exe/cpp/…) are available…There is no sensitive data…
A short running test…
|Nom de la fonction|Total [unit, %]|Self [unit, %]|Nombre d’appels|Module|
|-|-|-|-|-||*+*D:\users\phili\Downloads\Test_ADO_Cpp_VB\test_minimal\x64\Release\test.exe (PID : )|115,73s (100,00*%)|0ns (0,00*%)|0|Plusieurs modules|
||*+*__report_gsfailure|115,73s (100,00*%)|9,20?s (0,00*%)|1|test|
|||*+*__scrt_common_main_seh|115,73s (100,00*%)|13,20?s (0,00*%)|1|test|
||||*+*main|115,73s (100,00*%)|654,83ms (0,57*%)|1|test|
|||||*-*[Native] msado15.dll!0x00007ffe8947bc40|104,82s (90,58*%)|104,82s (90,58*%)|6215|msado15| <= AddNew() !!!
|||||*-*[Native] ucrtbase.dll!0x00007fff373ccad0|9,31s (8,05*%)|9,31s (8,05*%)|1|ucrtbase|
|||||*-*ADODB::Connection15::Open|413,29ms (0,36*%)|8,80?s (0,00*%)|2|test|
|||||*-*[Native] msado15.dll!0x00007ffe8947c010|101,83ms (0,09*%)|101,83ms (0,09*%)|2|msado15|
|||||*-*printf|96,90ms (0,08*%)|157,30?s (0,00*%)|214|test|
|||||*-*[Native] msado15.dll!0x00007ffe8947d3d0|91,69ms (0,08*%)|91,69ms (0,08*%)|74568|msado15|
|||||*-*[Native] msado15.dll!0x00007ffe8947d380|50,46ms (0,04*%)|50,46ms (0,04*%)|74568|msado15|
|||||*-*[Native] msado15.dll!0x00007ffe894d8fc0|30,92ms (0,03*%)|30,92ms (0,03*%)|149136|msado15|
|||||*-*[Native] msado15.dll!0x00007ffe8947bfc0|28,68ms (0,02*%)|28,68ms (0,02*%)|6214|msado15|
|||||*-*[Native] combase.dll!0x00007fff39403f10|26,94ms (0,02*%)|26,94ms (0,02*%)|5|combase|
|||||*-*[Native] msado15.dll!0x00007ffe89513fc0|17,39ms (0,02*%)|17,39ms (0,02*%)|149137|msado15|
|||||*-*[Native] msado15.dll!0x00007ffe894c1480|15,11ms (0,01*%)|15,11ms (0,01*%)|1|msado15|
|||||*-*[Native] msado15.dll!0x00007ffe8947c230|14,46ms (0,01*%)|14,46ms (0,01*%)|149137|msado15|
|||||*-Native]msado15.dll!0x00007ffe8947d2b0|11,32ms,01*%)|11,32ms,01*%)|149136|msado15|
Regards
Hi All, (Win10, Win11)To highlight a performance problem (with ADODB/ACCESS), on a heavy client, I wrote two small programs one in VB.NET (and VBA), the other in CPP/MFC. Using the same component (msado15.dll).This piece of code does nothing but connect to two ACCESS files (with a single table of 15,000 records), and via a recordset copy from one database to the other.Under VB.NET, it takes 1 second.Under CPP, on a machine that has the runtime access 2013 x64, it takes 9 seconds. (i spend 99% of my time in AddNew() )…Under CPP, on a machine that has the runtime access 2016 x64 OR Office365, it takes 20 minutes. (i spend 99% of my time in AddNew() )…The target computer must have Office365…I need an issue…PS : My two sln (exe/cpp/…) are available…There is no sensitive data…A short running test…|Nom de la fonction|Total [unit, %]|Self [unit, %]|Nombre d’appels|Module||-|-|-|-|-||*+*D:\users\phili\Downloads\Test_ADO_Cpp_VB\test_minimal\x64\Release\test.exe (PID : )|115,73s (100,00*%)|0ns (0,00*%)|0|Plusieurs modules|||*+*__report_gsfailure|115,73s (100,00*%)|9,20?s (0,00*%)|1|test||||*+*__scrt_common_main_seh|115,73s (100,00*%)|13,20?s (0,00*%)|1|test|||||*+*main|115,73s (100,00*%)|654,83ms (0,57*%)|1|test||||||*-*[Native] msado15.dll!0x00007ffe8947bc40|104,82s (90,58*%)|104,82s (90,58*%)|6215|msado15| <= AddNew() !!!|||||*-*[Native] ucrtbase.dll!0x00007fff373ccad0|9,31s (8,05*%)|9,31s (8,05*%)|1|ucrtbase||||||*-*ADODB::Connection15::Open|413,29ms (0,36*%)|8,80?s (0,00*%)|2|test||||||*-*[Native] msado15.dll!0x00007ffe8947c010|101,83ms (0,09*%)|101,83ms (0,09*%)|2|msado15||||||*-*printf|96,90ms (0,08*%)|157,30?s (0,00*%)|214|test||||||*-*[Native] msado15.dll!0x00007ffe8947d3d0|91,69ms (0,08*%)|91,69ms (0,08*%)|74568|msado15||||||*-*[Native] msado15.dll!0x00007ffe8947d380|50,46ms (0,04*%)|50,46ms (0,04*%)|74568|msado15||||||*-*[Native] msado15.dll!0x00007ffe894d8fc0|30,92ms (0,03*%)|30,92ms (0,03*%)|149136|msado15||||||*-*[Native] msado15.dll!0x00007ffe8947bfc0|28,68ms (0,02*%)|28,68ms (0,02*%)|6214|msado15||||||*-*[Native] combase.dll!0x00007fff39403f10|26,94ms (0,02*%)|26,94ms (0,02*%)|5|combase||||||*-*[Native] msado15.dll!0x00007ffe89513fc0|17,39ms (0,02*%)|17,39ms (0,02*%)|149137|msado15||||||*-*[Native] msado15.dll!0x00007ffe894c1480|15,11ms (0,01*%)|15,11ms (0,01*%)|1|msado15||||||*-*[Native] msado15.dll!0x00007ffe8947c230|14,46ms (0,01*%)|14,46ms (0,01*%)|149137|msado15||||||*-Native]msado15.dll!0x00007ffe8947d2b0|11,32ms,01*%)|11,32ms,01*%)|149136|msado15|Regards Read More
Adjacent column formulas not updated correctly on power query refresh
I have a query that reads a few csv files. It’s a simple query. There are a couple thousand rows, but it’s not complicated.
That data is loaded into a table.
I then added columns in excel, adjacent to the table with formula. Fairly straight forward.
Problem: When I update the query, new data comes in as expected, but the adjascent cells do not autofill down UNTIL you get to the last row of the new data where (somehow) the formula are filled across that row in all the adjascent columns. There’s litterally a gap between the last previous row of formula and the newly minted last row in the table.
I’ve tried several fixes, none have worked. Hoping someone can point me in the right direction. One thing I’m wondering is the whether the formula structure is causing an issue. I am not using structured formlas, rather simply referencing cells.
I have a query that reads a few csv files. It’s a simple query. There are a couple thousand rows, but it’s not complicated.That data is loaded into a table.I then added columns in excel, adjacent to the table with formula. Fairly straight forward.Problem: When I update the query, new data comes in as expected, but the adjascent cells do not autofill down UNTIL you get to the last row of the new data where (somehow) the formula are filled across that row in all the adjascent columns. There’s litterally a gap between the last previous row of formula and the newly minted last row in the table. I’ve tried several fixes, none have worked. Hoping someone can point me in the right direction. One thing I’m wondering is the whether the formula structure is causing an issue. I am not using structured formlas, rather simply referencing cells. Read More
MS Bookings Calendars being viewable in Outlook Shared Calendars
The trouble we have is that we are unable to see/share the bookings calendars in the our Outlook calendars with stakeholders & managers. All employees go through O365 to the bookings page and enter the calendar from there to look at it. If we were able to see the MS Bookings page calendar where we usually select shared calendars to view them side by side would be a huge benefit.
Does anyone know if this is at all possible. Or anyone else having this challenge?
The trouble we have is that we are unable to see/share the bookings calendars in the our Outlook calendars with stakeholders & managers. All employees go through O365 to the bookings page and enter the calendar from there to look at it. If we were able to see the MS Bookings page calendar where we usually select shared calendars to view them side by side would be a huge benefit.Does anyone know if this is at all possible. Or anyone else having this challenge? Read More
Fraudulant use
Lately, I have been seeing email with my user name and an addition to it like below:
email address removed for privacy reasons email address removed for privacy reasons.S7S <email address removed for privacy reasons email address removed for privacy reasons.S7S>
I want to know how to stop this kind of garbage from sending me what can only be described as junk and phishing emails. I cannot block them because Outlook states I cannot block my email address removed for privacy reasons email even though it really isn’t my email.
Anyone else experiencing this kind of garbage?
Frustrated Long-Time User (If you couldn’t tell from my hotmail.com address),
Ray
Lately, I have been seeing email with my user name and an addition to it like below:email address removed for privacy reasons email address removed for privacy reasons.S7S <email address removed for privacy reasons email address removed for privacy reasons.S7S>I want to know how to stop this kind of garbage from sending me what can only be described as junk and phishing emails. I cannot block them because Outlook states I cannot block my email address removed for privacy reasons email even though it really isn’t my email. Anyone else experiencing this kind of garbage?Frustrated Long-Time User (If you couldn’t tell from my hotmail.com address),Ray Read More
Sharepoint Online – 4000 site permissions adjustment query
Hi everyone, im hoping for some recommendations/advice. We have around 4000 sharepoint sites for Devices that currently have a single document library named Projects and some sub-folders in there created using pnp site provisioning. Every site is identical.
The permissions are currently dynamic where by the Members group has a security group added that ensures all active licensed users can access.
We have a requirement to start provisioning new sites where by two of the folders within the Projects library will have custom permissions which means breaking the inheritance and then adding another security group in however from what i have read this is against best practices.
Also it doesn’t help us as this will then need doing on the 4000 existing sites and having that many sites to manage at a unique level seems very scary.
What can be done here to block access to a couple of folders at tenant level for so many sites without needing to break inheritance of permissions.
Or is there no way, would one alternative be to create a new master site where every “Device” was a document library in this site (Around 4000) then the two folders in there and have a security group then assigned to the root members of that site fixing the permission requirement.
Thankyou,
Hi everyone, im hoping for some recommendations/advice. We have around 4000 sharepoint sites for Devices that currently have a single document library named Projects and some sub-folders in there created using pnp site provisioning. Every site is identical. The permissions are currently dynamic where by the Members group has a security group added that ensures all active licensed users can access. We have a requirement to start provisioning new sites where by two of the folders within the Projects library will have custom permissions which means breaking the inheritance and then adding another security group in however from what i have read this is against best practices. Also it doesn’t help us as this will then need doing on the 4000 existing sites and having that many sites to manage at a unique level seems very scary. What can be done here to block access to a couple of folders at tenant level for so many sites without needing to break inheritance of permissions. Or is there no way, would one alternative be to create a new master site where every “Device” was a document library in this site (Around 4000) then the two folders in there and have a security group then assigned to the root members of that site fixing the permission requirement. Thankyou, Read More
Windows Insider Program Feedback Sign In
I am getting an error message “Can’t sign you in”, error code CAA20003 when accessing Windows Insider Program Feedback from Windows Update. I have Windows 11. I follow the prompt to check Outlook and acknowledge the request. This completes just fine. I also tried the feedback hub app from the website.
I am getting an error message “Can’t sign you in”, error code CAA20003 when accessing Windows Insider Program Feedback from Windows Update. I have Windows 11. I follow the prompt to check Outlook and acknowledge the request. This completes just fine. I also tried the feedback hub app from the website. Read More
Copy existing formulas into Advanced Formula Environment module?
I haven’t found any guidance here or elsewhere on copying existing LAMBDA functions from a workbook into a module in AFE so that I can export it into a GitHub Gist for reuse in other workbooks.
I could copy & paste one at a time … but in some cases it would be onerous!
Situation: I have a few workbooks with several LAMBDA functions defined as “Names”. I can bring up the list in AFE:
The “duplicate” button creates the copy only in the workbook with no option to move it to a module. I can “paste” the definitions in “Formulas>Use In Formula>Paste Names” from the menu and paste them into the module text, but then lose the comments (“Creates string with…” in the image).
Am I missing something?
Thanks!
I haven’t found any guidance here or elsewhere on copying existing LAMBDA functions from a workbook into a module in AFE so that I can export it into a GitHub Gist for reuse in other workbooks.I could copy & paste one at a time … but in some cases it would be onerous! Situation: I have a few workbooks with several LAMBDA functions defined as “Names”. I can bring up the list in AFE: The “duplicate” button creates the copy only in the workbook with no option to move it to a module. I can “paste” the definitions in “Formulas>Use In Formula>Paste Names” from the menu and paste them into the module text, but then lose the comments (“Creates string with…” in the image). Am I missing something? Thanks! Read More