Hi,

Below formula throwing #Calc error:

Need one array formula.

Sheet

​Hi, Below formula throwing #Calc error:BYCOL(C3#,LAMBDA(ColHdrs_1,BYROW(B4#,LAMBDA(RowHdrs_1,IFERROR(COUNTA(UNIQUE(FILTER($K$3:$K$25,($I$3:$I$25=RowHdrs_1)*($J$3:$J$25=ColHdrs_1)))),0))))) Need one array formula.Sheet  Read More

​

Hello everyone,

please help me out, as I am starting to despair. Here’s what I am trying to do:

I have a List of processes and a separate List of all process steps of all processes. I am using a lookup field to connect those steps to their respective process. For easier use, I want to create a SharePoint page for each process, showing, among other things, a list of the steps of this specific process.

Seems straightforward but, for now, I haven’t found a way to create this filtered view on the List of steps in an embed.

I’ve tried three ways:

1. Using the List web part, there seems to be no way to define a fixed filter.

2. Using a list view filtered by URL parameters embedded using the embed web part – technically works but looks ugly, as it doesn’t display only the list, but several control bars, which I can only remove in parts using JSON view formatting. The “?env=Embedded” parameter also seems to be doing nothing…

3. Creating a pre-defined list view in Lists and embedding this – also technically works but is a lot of manual work and there appears to be no way to filter a view on a hidden column, so I would have to display the name of the process as well which is redundant information.

My last resort would be creating a separate List for each process, but that seems a bit excessive and would massively hinder further extensions of the system.

Any other ideas?

Thanks!

 Nils

​Hello everyone, please help me out, as I am starting to despair. Here’s what I am trying to do: I have a List of processes and a separate List of all process steps of all processes. I am using a lookup field to connect those steps to their respective process. For easier use, I want to create a SharePoint page for each process, showing, among other things, a list of the steps of this specific process. Seems straightforward but, for now, I haven’t found a way to create this filtered view on the List of steps in an embed. I’ve tried three ways: 1. Using the List web part, there seems to be no way to define a fixed filter. 2. Using a list view filtered by URL parameters embedded using the embed web part – technically works but looks ugly, as it doesn’t display only the list, but several control bars, which I can only remove in parts using JSON view formatting. The “?env=Embedded” parameter also seems to be doing nothing… 3. Creating a pre-defined list view in Lists and embedding this – also technically works but is a lot of manual work and there appears to be no way to filter a view on a hidden column, so I would have to display the name of the process as well which is redundant information. My last resort would be creating a separate List for each process, but that seems a bit excessive and would massively hinder further extensions of the system. Any other ideas? Thanks! Nils     Read More

​

I am using OneDrive on Windows 11. I manage all my files with OneDrive. I manage the documents with the Windows Explorer file structure on my computer by creating a shortcut via MS Teams or SharePoint.
OneDrive is always in sync mode on my computer. It updates automatically whenever I make changes to any file. But the important detail is “when I update” 🙂
I have a problem with OneDrive for a while. I don’t know if this is due to OneDrive.
When I open any file, the file is somehow automatically saved and synced to OneDrive, even if I don’t make any changes to the file. Unfortunately, this way I miss the previous modification date of the file etc.
Of course, I can go and look at this in the version history, but the date of the last permanent file is updated as my current file opening date.
This is not something that happens in every file, but it becomes annoying because I cannot predict when it will happen or not.
Has anyone ever encountered a similar situation and found a solution?
Thank you in advance for your reply.

​I am using OneDrive on Windows 11. I manage all my files with OneDrive. I manage the documents with the Windows Explorer file structure on my computer by creating a shortcut via MS Teams or SharePoint.OneDrive is always in sync mode on my computer. It updates automatically whenever I make changes to any file. But the important detail is “when I update” :)I have a problem with OneDrive for a while. I don’t know if this is due to OneDrive.When I open any file, the file is somehow automatically saved and synced to OneDrive, even if I don’t make any changes to the file. Unfortunately, this way I miss the previous modification date of the file etc.Of course, I can go and look at this in the version history, but the date of the last permanent file is updated as my current file opening date.This is not something that happens in every file, but it becomes annoying because I cannot predict when it will happen or not.Has anyone ever encountered a similar situation and found a solution?Thank you in advance for your reply.  Read More

​

I have a process that exports two sets of identical Excel files – a first set where users can edit data and a second reference set that enables file compare to identify updates made in the first set. Each file has only one sheet and the file name is the sheet name plus extension.

I need a macro to loop through both sets of files and highlight the updates in the first (edited) set, but I cannot get the loop through the set of edited files to work. I have tried both While Wend and For Each Next. My code runs, but does nothing.

Help to identify my error greatly appreciated!

Sub Compare_Spreadsheets_While_Wend3()
Dim editPath, refPath, filename, refFname As String
Dim editwbk, refwbk As Workbook
Dim editws, refws As Worksheet
Dim wbk, FileSystem, Folder, editFile, refFile, FSO, editFolder As Object

editPath = “C:pathSet_1”
refPath = “C:pathSet_2”

‘Loop through files in reference folder
refFile = refPath & “*.xls*”
While refFile <> “”

refFname = ActiveWorkbook.Name

Set FileSystem = CreateObject(“Scripting.FileSystemObject”)
Set editFolder = FileSystem.GetFolder(editPath)

For Each editFile In editFolder.Files
filename = editFile.Name

‘Problem here

If editFile.Name = refFname Then

Set editwbk = Workbooks.Open(editPath & “” & filename)
For Each editws In editwbk.Worksheets
If editws.Name = refws.Name Then
For Each cell In editws.Range(“A1”).CurrentRegion
If cell.Value <> refws.Range(cell.Address).Value Then
cell.Interior.Color = vbYellow
MsgBox “Changed value in ” & cell.Address & ” in sheet ” & editws.Name
End If
Next cell
Exit For
End If
Next editws
Exit For
editwbk.Close SaveChanges:=True

End If
Next editFile

Wend

End Sub

​I have a process that exports two sets of identical Excel files – a first set where users can edit data and a second reference set that enables file compare to identify updates made in the first set. Each file has only one sheet and the file name is the sheet name plus extension.I need a macro to loop through both sets of files and highlight the updates in the first (edited) set, but I cannot get the loop through the set of edited files to work. I have tried both While Wend and For Each Next. My code runs, but does nothing.Help to identify my error greatly appreciated!Sub Compare_Spreadsheets_While_Wend3()
Dim editPath, refPath, filename, refFname As String
Dim editwbk, refwbk As Workbook
Dim editws, refws As Worksheet
Dim wbk, FileSystem, Folder, editFile, refFile, FSO, editFolder As Object

editPath = “C:pathSet_1”
refPath = “C:pathSet_2”

‘Loop through files in reference folder
refFile = refPath & “*.xls*”
While refFile <> “”

refFname = ActiveWorkbook.Name

Set FileSystem = CreateObject(“Scripting.FileSystemObject”)
Set editFolder = FileSystem.GetFolder(editPath)

For Each editFile In editFolder.Files
filename = editFile.Name

‘Problem here

If editFile.Name = refFname Then

Set editwbk = Workbooks.Open(editPath & “” & filename)
For Each editws In editwbk.Worksheets
If editws.Name = refws.Name Then
For Each cell In editws.Range(“A1”).CurrentRegion
If cell.Value <> refws.Range(cell.Address).Value Then
cell.Interior.Color = vbYellow
MsgBox “Changed value in ” & cell.Address & ” in sheet ” & editws.Name
End If
Next cell
Exit For
End If
Next editws
Exit For
editwbk.Close SaveChanges:=True

End If
Next editFile

Wend

End Sub  Read More

​

After registering, I was contacted by Microsoft support (verification department) and asked for additional information:

We are from the verification department, and we need additional information to properly resolve the problem you are experiencing.

To help us resolve your case, we need to verify both your identity and your association with the non-profit organization for which you are requesting sponsorship. Please provide us with the necessary documentation to facilitate this verification process, which will allow us to quickly resolve your issue.

Please provide the following additional information, among other relevant details:
Organizational URL/website – if applicable
A photo or scanned copy of your employee identification card
Government-issued documentation not publicly available concerning your Nonprofit Organization
Confirmation email from your nonprofit organization’s domain, affirming that you are acting on their behalf and outlining your association with the organization, etc.
If you have any additional information that you consider relevant for our consideration, please include it in your response.

We sincerely apologize for any inconvenience this may cause and eagerly anticipate your prompt reply. If we do not receive a response within the next 48 hours, regrettably, the case will be closed.

I provided my organization’s website and my email address at the organization so they can contact me, so I can verify I can receive email at my organization’s domain.

I wasn’t able to provide the other information because my organization doesn’t have employee id cards. I also asked what specific government issued documentation was requested, because the request was nondescript.

The response I got back was:

Thank you again for reaching out and for applying for nonprofit status with Microsoft. However, we have been unable to determine the veracity of the account details you have provided and are unable to process your account for offers through the Nonprofit Portal.

We will be archiving this ticket at this time. Should you disagree with this assessment, please feel free to open a new ticket with additional verifiable documentation.

This was disappointing. The ticket was closed without me really knowing what it was about or me given a reasonable chance to provide what was requested.

Any advice?

​After registering, I was contacted by Microsoft support (verification department) and asked for additional information:We are from the verification department, and we need additional information to properly resolve the problem you are experiencing.

To help us resolve your case, we need to verify both your identity and your association with the non-profit organization for which you are requesting sponsorship. Please provide us with the necessary documentation to facilitate this verification process, which will allow us to quickly resolve your issue.

Please provide the following additional information, among other relevant details:
Organizational URL/website – if applicable
A photo or scanned copy of your employee identification card
Government-issued documentation not publicly available concerning your Nonprofit Organization
Confirmation email from your nonprofit organization’s domain, affirming that you are acting on their behalf and outlining your association with the organization, etc.
If you have any additional information that you consider relevant for our consideration, please include it in your response.

We sincerely apologize for any inconvenience this may cause and eagerly anticipate your prompt reply. If we do not receive a response within the next 48 hours, regrettably, the case will be closed. I provided my organization’s website and my email address at the organization so they can contact me, so I can verify I can receive email at my organization’s domain.I wasn’t able to provide the other information because my organization doesn’t have employee id cards. I also asked what specific government issued documentation was requested, because the request was nondescript.  The response I got back was: Thank you again for reaching out and for applying for nonprofit status with Microsoft. However, we have been unable to determine the veracity of the account details you have provided and are unable to process your account for offers through the Nonprofit Portal.

We will be archiving this ticket at this time. Should you disagree with this assessment, please feel free to open a new ticket with additional verifiable documentation.  This was disappointing. The ticket was closed without me really knowing what it was about or me given a reasonable chance to provide what was requested. Any advice?     Read More

​

I have unable to access the account and it says “Your sign-in was successful but does not meet the criteria to access this resource. For example, you might be signing in from a browser, app, or location that is restricted by your admin.”

I have setup all my payment details. and already bank has created the mandate with huge amount. I am bit worried. Please help me to login to my account and also help me to remove the my payment details if in case I am unable to login to portal.

​I have unable to access the account and it says “Your sign-in was successful but does not meet the criteria to access this resource. For example, you might be signing in from a browser, app, or location that is restricted by your admin.” I have setup all my payment details. and already bank has created the mandate with huge amount. I am bit worried. Please help me to login to my account and also help me to remove the my payment details if in case I am unable to login to portal.  Read More

​