What exactly does the option "Make instance visible" do in "Launch Excel"?

(1) Share

Report

Posted on by Mdarkx

Hello,

I'm having a weird issue with Excel. Perhaps it's just me misunderstand the option, but I figured I would ask.

If I have the option off PAD hides the sheet I'm automating. So when the flow has run, and I open the worbook, its completely grey and sheet is hidden (see photo below for reference)

If I have the option on there is no issues at all. Sheet is not hidden when I open the workbook afterwards.

I thought the option was wether or not I would show Excel during the automation, but did i misunderstand that?

Looking forward to any answers.

Kind regards.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (13)

Answers (0)

SA_VOH 210 on at

Like (0)

Report

Hi,
The "Make instance visible" will make the Excel file you are trying to open , visible to you.
The problem of getting blanked sheet was resolved in my case, was first launch the excel , do some work, then save it and then close it.
Please note that saving and closing is required to be done in 2 separate steps not one.

Was this reply helpful? Yes No
Mdarkx 10 on at

Like (0)

Report

Hi,

Thanks for the reply.

I tried saving and closing in seperate steps - still the same issue.

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

Check out some options

- https://www.youtube.com/watch?v=ZbkZSPe0_wY

- https://docs.microsoft.com/en-us/office/troubleshoot/excel/excel-opens-blank

Was this reply helpful? Yes No
Mdarkx 10 on at

Like (0)

Report

Hi,

Thanks for the links. It's not really an Excel issue, but an issue with PAD.

For some reason PAD hides the sheet if "Make instance visible" is set to off. No issues if the option is set to on.

Was this reply helpful? Yes No
Mdarkx 10 on at

Like (0)

Report

Anyone else got something I could try to solve this issue?

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report

My guess is that you're in Page Break view. Activate the View tab of the ribbon and click the first button: Normal.

Was this reply helpful? Yes No
liuliucai 4 on at

Like (0)

Report

my some problem。do u solve?

Was this reply helpful? Yes No
lemonroti 3 on at

Like (0)

Report

Do u have the solution ? I also facing the same problem

Was this reply helpful? Yes No
Mdarkx 10 on at

Like (0)

Report

To anyone finding this thread. I sadly never found a solution. Still facing this issue. Switched to UiPath instead and no issues here.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report

My guess would be the "Make Instance Visible = False" is a "Hide Workbook" setting within Excel and PAD doesn't correct this when it is done. So, at the very end of the flow, I would add:

Launch Excel with Make Instance Visible = True

Save and Close Excel

This should turn that option back on and then it won't be grayed out when you open it in the future.

Good luck!

Was this reply helpful? Yes No