Unanswered

Why my excel data are all missing after save document

(0) Share

Report

Posted on by sophia111

Hi,

I have an Excel file with data. After executing this code, when I open it again, it looks like it's damaged as shown in the picture. Why is this happening? Thanks!!

Best,

Sophia

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@sophia111

Is this happening for only this excel file? you can also try to do the same process for other excel file and observe the results.

Thanks,
Deenuji Loganathan
🤖Automation Evangelist
Deenuji - Follow me on LinkedIn

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

Was this reply helpful? Yes No
Riyaz_riz11 3,844 Super User 2025 Season 2 on at

Like (0)

Report
@sophia111 ,

So the thing is , you are launching the excel and save but not closing before that you are trying to open,

try to complete all action and try.

2nd instead of save as use close excel inside properties.

Refer image:

If you want to kill excel use this code:

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

Regards,
Riyaz

Scripting.RunDOSCommand.RunDOSCommand DOSCommandOrApplication: $'''taskkill /f /im excel.exe'''

Was this reply helpful? Yes No
sophia111 31 on at

Like (0)

Report

Hi, Deenuji,

I have tried another excel file, it also appeared.
And FYI, When the process reached first step Lacunch Excel, the file was still in good condition, and this issue only occurred after Save Excel, when I tried to switch to Close Excel and chose Save document, the same problem still occurred.
Best,
Sophia

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@sophia111
If possible could you please share your code after removing all sensitive data? Just I am try to reproduce the same issue in my system.

Thanks,
Deenuji Loganathan
🤖 Automation Evangelist
Deenuji - Follow me on LinkedIn

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

Was this reply helpful? Yes No
VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (0)

Report

Hi @sophia111 ,

Can you share the excel file personally if it does not contain any sensitive data?

Regards,
Vishnu Reddy

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

The file is not damaged. It's just that the workbook has been hidden. Please refer to this article on how to unhide it: https://earnandexcel.com/blog/how-to-unhide-an-excel-workbook-a-comprehensive-guide/

I know a few cases where PAD does this. The only way we have found to avoid it is making the instance visible in Launch Excel. When you do that, the workbook does not get hidden.

Was this reply helpful? Yes No