Issue with Power Auotmate Flow Excel Sheet is Blocked for around 30 min. after Opening with...

Ilooo58 · 20. Januar 2023

I have built a flow that when a file is created or modified executes a script in an Excel file to return the value of a cell as Jason. Once I run the flow the script runs fine I get the data I then query the file properties in sharepoint and when I try to change the metadata I get the error as follows: The file "URL EXEL DATA" is locked for sharing by MY OWN EMAIL. if i add a delay of 30 min before doing the last step change meta data it works. i have tried this with different wait times sometimes it works after 10 min sometimes after 20 min but in any case after 30 min every time. my que

RobIreland12

Hi there,

Did you manage to resolve this issue. It is the same I have encountered. I have removed Power Map and reinstalled Office. My issue started after I changed the Graphics Settings but can't establish if they are stored in the registry or the file system.

A really annoying issue with a great product.

Regards

Rob Ireland

Ismet Kocaman

How is the progress with that issue ?

Claus Busch

Hallo,

schreibe in das vorhandene Tabellenblatt das Datum des ersten Arbeitstages in A1 und füge die gewünschten Inhalte dazu.

Rufe dann folgendes Makro auf:

Sub BlätterEinfügen()

Dim Last As Integer, First As Integer, i As Integer, Tage As Integer

Application.ScreenUpdating = False

With ActiveSheet

   First = Day(.Range("A1"))

   Last = Day(Application.EoMonth(.Range("A1"), 0))

   Tage = Application.NetworkDays(First, Last)

   .Name = .Range("A1")

End With

For i = 2 To Tage

   Select Case Weekday(Sheets(i - 1).Range("A1"), 2)

      Case Is < 5

         Sheets(i - 1).Copy after:=Sheets(i - 1)

         ActiveSheet.Range("A1") = Sheets(i - 1).Range("A1") + 1

         ActiveSheet.Name = Range("A1")

      Case 5

         Sheets(i - 1).Copy after:=Sheets(i - 1)

         ActiveSheet.Range("A1") = Sheets(i - 1).Range("A1") + 3

         ActiveSheet.Name = Range("A1")

   End Select

Next

Application.ScreenUpdating = True

End Sub

Claus

Claus Busch

Hallo,

probiere es mal so:

Sub Test()

Worksheets.Add after:=Sheets(Sheets.Count)

ActiveSheet.Name = "Mail"

Sheets("Tabelle1").UsedRange.CopyWith Sheets("Mail")

    .Range("A1").PasteSpecial xlPasteValues

    .Move

End With

With ActiveWorkbook

    .SaveAs ThisWorkbook.Path & "\" & "Mail.xlsx"

    .Close

End With

End Sub

Es wird ein neues Blatt nur mit Werten angelegt, in eine neue Mappe verschoben und diese im gleichen Ordner unter dem Namen "Mail" gespeichert.

Claus

Jörg Spiecker

Hallo Andreas,
es geht um das impletieren in folgendes Makro von Claus Busch:
Sub BlätterEinfügen()
Dim Last As Integer, First As Integer, i As Integer, Tage As Integer

Application.ScreenUpdating = False
With ActiveSheet
First = Day(.Range("A1"))
Last = Day(Application.EoMonth(.Range("A1"), 0))
Tage = Application.NetworkDays(First, Last)
.Name = .Range("A1")
End With
For i = 2 To Tage
Select Case Weekday(Sheets(i - 1).Range("A1"), 2)
Case Is < 5
Sheets(i - 1).Copy after:=Sheets(i - 1)
ActiveSheet.Range("A1") = Sheets(i - 1).Range("A1") + 1
ActiveSheet.Name = Range("A1")
Case 5
Sheets(i - 1).Copy after:=Sheets(i - 1)
ActiveSheet.Range("A1") = Sheets(i - 1).Range("A1") + 3
ActiveSheet.Name = Range("A1")
End Select
Next
Application.ScreenUpdating = True
End Sub

Dieses legt aufgrund eines Datums in A1 für den restlichen Monat Tabellenblätter mit dem fortlaufenden Datum ohne WE an.
Ich würde aber zu dem Datum auch gerne Voarangestellt den Wochentag haben. Geht das?
Danke für die >Hilfe

Hi,

willkommen im Windows Forum!

Issue with Power Auotmate Flow Excel Sheet is Blocked for around 30 min. after Opening with... - Similar Threads - Issue with Power	Forum	Datum
ERR_ADDRESS_UNREACHABLE // Issue with Windows itself. ERR_ADDRESS_UNREACHABLE // Issue with Windows itself.: I desperately need some help cause i tried everything and i am on the edge of wiping my entire computer clean and resetting it completely. Since 2-3 days ago i have an issue where my WIFI Shows...	Apps	26. April 2024
List with power apps form still opening Sharepoint form List with power apps form still opening Sharepoint form: We migrated the SharePoint site from 2019 to online .The list was migrated along with custom form. Now we are using power app form on the same list. But it is still opening the old form .The list...	Microsoft Office	20. Februar 2024
Scheduled refresh for Power Bi dataset with data from an Excel sheet Scheduled refresh for Power Bi dataset with data from an Excel sheet: According to the Microsoft page you have to do that by publishing the Excel sheet to Power Bi https://learn.microsoft.com/en-us/power-bi/connect-data/service-excel-workbook-files blue box in the...	Microsoft Office	25. Oktober 2023
Issue with TPM Issue with TPM: Ich erhalte jedes mal diese Anzeige wenn ich den laptop einschalte. Ich weiß nicht was das heißt und was zu tun ist damit ich das behebe. Um mit den Laptop bisher arbeiten zu können wähle ich...	Apps	28. Juli 2022
Issue with TPM Issue with TPM: Ich erhalte jedes mal diese Anzeige wenn ich den laptop einschalte. Ich weiß nicht was das heißt und was zu tun ist damit ich das behebe. Um mit den Laptop bisher arbeiten zu können wähle ich...	Games und Spiele	28. Juli 2022
Sharepoint Issues with VBA Sharepoint Issues with VBA: Hi Guys, We moved our old Harddrive Datas on an mircrosoft cloud, where datas can be retrieved via sharepoint drive Since we moved all our datas on the sharepoint, we are facing frequently...	Microsoft Office	20. August 2020
Next/End With zu For/With wird nicht akteptiert. Next/End With zu For/With wird nicht akteptiert.: Hallo. Ich habe ein kleines Modul erstellt, um eine Funktion zu testen. Dies wäre der Code. Sub BereicheVergleichen() Dim rngZelle As Range Dim rngBereich As Range Dim rngZiel As Range...	Microsoft Office	27. November 2019

Issue with Power Auotmate Flow Excel Sheet is Blocked for around 30 min. after Opening with...

Issue with Power Auotmate Flow Excel Sheet is Blocked for around 30 min. after Opening with...

Excel 2013 Power Map Error - 1.0.531.0 und fehlende Schaltflächen

Gliederungsebenen bei Copy/Paste aus Word

Blätter mit fortlaufendem Datum erstellen

Nur ausgefüllte Zellen (ohne Formeln) in ein neues Dokument verschieben.

Automatische Tabellenblatterstellung

User Advert

Issue with Power Auotmate Flow Excel Sheet is Blocked for around 30 min. after Opening with... - Microsoft Office

Issue with Power Auotmate Flow Excel Sheet is Blocked for around 30 min. after Opening with... - Similar Threads - Issue with Power

ERR_ADDRESS_UNREACHABLE // Issue with Windows itself.

List with power apps form still opening Sharepoint form

Scheduled refresh for Power Bi dataset with data from an Excel sheet

Issue with TPM

Issue with TPM

Sharepoint Issues with VBA

Next/End With zu For/With wird nicht akteptiert.

Issue with Power Auotmate Flow Excel Sheet is Blocked for around 30 min. after Opening with... solved