I am converting a spreadsheet from OpenOffice to Excel. OpenOffice has a window in its “ribbon”  that allows you to enter a term and the program will “find” the next cell with that term and then let you find the next entry of it, and so on.  Excell has a find function and a search function, but they have more steps and are more complicated. Am I missing something simple in Excel that does the same thing?

​I am converting a spreadsheet from OpenOffice to Excel. OpenOffice has a window in its “ribbon”  that allows you to enter a term and the program will “find” the next cell with that term and then let you find the next entry of it, and so on.  Excell has a find function and a search function, but they have more steps and are more complicated. Am I missing something simple in Excel that does the same thing?  Read More

​

We are running FSLogix 2.9.8884.27471 on Server 2022.  Our domain controllers are all Server 2022.  We just migrated to a new file server.  The Citrix profiles are stored on a completely different server; we have not changed the Citrix profile file server.  We only changed/migrated the general file server used for general file storage.

After we powered off the old file server, Citrix users complained of “slowness” when using File Explorer.  We discovered that there are a bunch of references to the old file server in each user’s FSLogix profile registry.  If we mount the FSLogix profile, when a user is logged out, and delete the references from a user’s profile registry, the “slowness” issues with File Explorer, are resolved.  The registry entries that seem to be present in each user’s profile are located in the following:

HKUFSL.VHD.****SoftwareMicrosoftWindowsCurrentVersionExplorerMountPoints 2 (there are a couple mount points still present for the old file server) 

HKUFSL.VHD.****SoftwareMicrosoftWindowsCurrentVersionExplorerShell Folders (we use GPO to redirect a users “Favorites” folder – the old file server is still listed in the “Favorites” registry entry, even though the GPO is setup to point to the new file server)

HKUFSL.VHD.****SoftwareMicrosoftWindowsCurrentVersionExplorerUser Shell Folders (we use GPO to redirect a users “Favorites” folder – the old file server is still listed in the “Favorites” registry entry, even though the GPO is setup to point to the new file server)

When we delete the “Favorites” entries, we find that after a user logs in/out, the “Favorites” entry updates properly to the new file server path.

We can also remedy the File Explorer “slowness” by simply powering on the old file server.  Again, all of the sharing on the old file server has been disabled.  So it seems like as long as a user can “ping” the old file server, then that’s all FSLogix needs to ensure that File Explorer works.

This issue does not occur on physical Windows computers/servers- only with with FSLogix profiles.

Instead of either leaving on the old file server powered on, or manually editing the registry in each user’s profile, is there a way to remove (or update) these registry entries that point to the old file server?

​We are running FSLogix 2.9.8884.27471 on Server 2022.  Our domain controllers are all Server 2022.  We just migrated to a new file server.  The Citrix profiles are stored on a completely different server; we have not changed the Citrix profile file server.  We only changed/migrated the general file server used for general file storage. After we powered off the old file server, Citrix users complained of “slowness” when using File Explorer.  We discovered that there are a bunch of references to the old file server in each user’s FSLogix profile registry.  If we mount the FSLogix profile, when a user is logged out, and delete the references from a user’s profile registry, the “slowness” issues with File Explorer, are resolved.  The registry entries that seem to be present in each user’s profile are located in the following: HKUFSL.VHD.****SoftwareMicrosoftWindowsCurrentVersionExplorerMountPoints 2 (there are a couple mount points still present for the old file server)  HKUFSL.VHD.****SoftwareMicrosoftWindowsCurrentVersionExplorerShell Folders (we use GPO to redirect a users “Favorites” folder – the old file server is still listed in the “Favorites” registry entry, even though the GPO is setup to point to the new file server) HKUFSL.VHD.****SoftwareMicrosoftWindowsCurrentVersionExplorerUser Shell Folders (we use GPO to redirect a users “Favorites” folder – the old file server is still listed in the “Favorites” registry entry, even though the GPO is setup to point to the new file server) When we delete the “Favorites” entries, we find that after a user logs in/out, the “Favorites” entry updates properly to the new file server path. We can also remedy the File Explorer “slowness” by simply powering on the old file server.  Again, all of the sharing on the old file server has been disabled.  So it seems like as long as a user can “ping” the old file server, then that’s all FSLogix needs to ensure that File Explorer works. This issue does not occur on physical Windows computers/servers- only with with FSLogix profiles. Instead of either leaving on the old file server powered on, or manually editing the registry in each user’s profile, is there a way to remove (or update) these registry entries that point to the old file server?     Read More

​

Microsoft 365 Insiders,

Great news for Excel enthusiasts! Get ready to enhance your Excel game with regex modes for XLOOKUP and XMATCH. Whether you’re pulling specific data or locating exact matches, these updates help parse text more easily.

Jake Armstrong, Product Manager on the Excel team, breaks it all down for you in our latest blog: New regex modes for XLOOKUP and XMATCH

Thanks!

Perry Sjogren

Microsoft 365 Insider Community Manager

Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android

​Microsoft 365 Insiders,
 
Great news for Excel enthusiasts! Get ready to enhance your Excel game with regex modes for XLOOKUP and XMATCH. Whether you’re pulling specific data or locating exact matches, these updates help parse text more easily.
 
Jake Armstrong, Product Manager on the Excel team, breaks it all down for you in our latest blog: New regex modes for XLOOKUP and XMATCH
 
Thanks!
 
Perry Sjogren
Microsoft 365 Insider Community Manager
 
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android  Read More

​

The SharePoint Embedded product team is coming to New York City and London in September! Come join us for an all-day event to learn how SharePoint Embedded can deliver Copilot, Collaboration, Compliance, and Core Enterprise Storage for your document centric apps. 

Specifically, you’ll have the opportunity to do the following:

Learn about SharePoint Embedded, a new way to build file and document centric apps.
Get hands-on coding experience with this new technology and learn how to build your own custom app.
Take a deep dive into critical features, like compliance, collaboration and copilot.
Hear from others who have implemented SharePoint Embedded solutions.
Get insight into the SharePoint Embedded roadmap

New York City, US
Date: Thursday, September 12th, 9AM-7PM (times are approximate, including social hour)
Where: Microsoft Offices NYC Times Square 

London, UK
Date: Thursday, September 26th, 9AM-7PM (times are approximate, including social hour)
Where: Central London, UK (Exact location TBD)

RSVP Details (Please note that this event is only open to certain countries and the following will not be accepted: Russia, Belarus)

21+, free event, no registration fees
First come, first served (limited seats)

1 RSVP = 1 person 

NDA required (if your company does not have an NDA on record, one will be sent)

NDA must be signed to attend event

Event will be IN PERSON ONLY and will not be recorded

Bring your own device for coding portions (tablets and smartphones will not work)

To register for one or more of these events visit Microsoft SharePoint Embedded for Enterprise Apps (office.com).

​Microsoft Tech Community – Latest Blogs –Read More 

We have created a solution that invites the Microsoft Teams media bot to an online teams meeting. Unfortunately the bot does not always seem to join the call. 

In these cases;
We only receive the “Establishing…” callback, but then the call is never actually transfered to “Established”. After waiting for about 60 seconds. We receive the “Terminated” signal, without the call ever reaching the “established” state.

Along with this terminated callback, we also receive the following error code (for which we can not find any documentation..)

Server Internal Error. DiagCode: 500#7117.@

The steps and conditions of inviting the bot are always the same.
1. Create New meeting
2. Invite bot to meeting
3. 50% (sometimes lower, sometimes higher) chance bot will join

A workaround I found was, inviting the bot multiple times. Which sometimes work, but the bot is then kicked subsequently when the “Terminated” callback is sent our way.

await this.Client.Calls().AddAsync(joinParams).ConfigureAwait(false);

This is the code to trigger the invitation of the bot, as per the microsoft sample. (docs)

Can someone please shed some light on the meaning of this error code? I have not found any patterns in its occurrence and our calls to the service do not change. The only difference likely being a different meetingId. 

Server Internal Error. DiagCode: 500#7117.@

​We have created a solution that invites the Microsoft Teams media bot to an online teams meeting. Unfortunately the bot does not always seem to join the call. In these cases;We only receive the “Establishing…” callback, but then the call is never actually transfered to “Established”. After waiting for about 60 seconds. We receive the “Terminated” signal, without the call ever reaching the “established” state.Along with this terminated callback, we also receive the following error code (for which we can not find any documentation..)Server Internal Error. DiagCode: 500#7117.@The steps and conditions of inviting the bot are always the same.1. Create New meeting2. Invite bot to meeting3. 50% (sometimes lower, sometimes higher) chance bot will joinA workaround I found was, inviting the bot multiple times. Which sometimes work, but the bot is then kicked subsequently when the “Terminated” callback is sent our way. await this.Client.Calls().AddAsync(joinParams).ConfigureAwait(false);  This is the code to trigger the invitation of the bot, as per the microsoft sample. (docs)Can someone please shed some light on the meaning of this error code? I have not found any patterns in its occurrence and our calls to the service do not change. The only difference likely being a different meetingId.  Server Internal Error. DiagCode: 500#7117.@   Read More

​

I have created table1 on tab Empl By Dept with headers for Employee, supervisor and dept.  I am using a drop down list on another tab of the same workbook to select data from this table. Per excel help when choosing my source for this drop down  it should put the table name references when I click on the  cell below the header name employee.  instead it puts the cell reference names ie…a2.  I have tried several variations shown in help trying to get the syntax right to pull this data.  I am wanting the drop down choices to automatically change if the table info changes.  Using table references is supposed to do this.  help….

​I have created table1 on tab Empl By Dept with headers for Employee, supervisor and dept.  I am using a drop down list on another tab of the same workbook to select data from this table. Per excel help when choosing my source for this drop down  it should put the table name references when I click on the  cell below the header name employee.  instead it puts the cell reference names ie…a2.  I have tried several variations shown in help trying to get the syntax right to pull this data.  I am wanting the drop down choices to automatically change if the table info changes.  Using table references is supposed to do this.  help….  Read More

​

I get the following JSON response from an API call

[
[
{
“field”: “ID”,
“value”: 29
},
{
“field”: “Created at”,
“value”: “06/08/2024 15:18”
},
{
“field”: “Created by”,
“value”: “Amanda”
},
{
“field”: “Job Card Status”,
“value”: “Final”
},
{
“field”: “Sales Amount”,
“value”: “2500”
}
],
[
{
“field”: “ID”,
“value”: 28
},
{
“field”: “Created at”,
“value”: “06/08/2024 15:16”
},
{
“field”: “Created by”,
“value”: “Amanda”
},
{
“field”: “Job Card Status”,
“value”: “Final”
},
{
“field”: “Sales Amount”,
“value”: “15400”
}
]
]

and need to create a table in Power Query for further processing. The table will have a column Date (from date created) and a column ‘Sales amount’ from Sales amount. No idea how do I approach this? 

​I get the following JSON response from an API call [
[
{
“field”: “ID”,
“value”: 29
},
{
“field”: “Created at”,
“value”: “06/08/2024 15:18”
},
{
“field”: “Created by”,
“value”: “Amanda”
},
{
“field”: “Job Card Status”,
“value”: “Final”
},
{
“field”: “Sales Amount”,
“value”: “2500”
}
],
[
{
“field”: “ID”,
“value”: 28
},
{
“field”: “Created at”,
“value”: “06/08/2024 15:16”
},
{
“field”: “Created by”,
“value”: “Amanda”
},
{
“field”: “Job Card Status”,
“value”: “Final”
},
{
“field”: “Sales Amount”,
“value”: “15400”
}
]
] and need to create a table in Power Query for further processing. The table will have a column Date (from date created) and a column ‘Sales amount’ from Sales amount. No idea how do I approach this?     Read More

​

Hello!

One thing that is driving me insane with this new Outlook is that it’s missing a lot of great functionality that the last version had. One example is Quick Steps doesn’t have the ‘new email’ option so that I can send to a group of contacts by adding all of their emails and saving. The Groups option only applies to contacts within your organization, which doesn’t help me because I need to send to outside contacts. 

How do I do this without adding them as contacts?

​Hello! One thing that is driving me insane with this new Outlook is that it’s missing a lot of great functionality that the last version had. One example is Quick Steps doesn’t have the ‘new email’ option so that I can send to a group of contacts by adding all of their emails and saving. The Groups option only applies to contacts within your organization, which doesn’t help me because I need to send to outside contacts.  How do I do this without adding them as contacts?  Read More

​