What is the correct work flow to add or remove worksheets to an existing Excel file used as an IA?
I have been able to do this before, but am having trouble now. I am getting the please close the Excel file error in composer.
I have tried to add to the Excel file while in Composer, add to the Excel file with Composer closed, modify a copy of the Excel file and overwrite the original… Nothing seems to work right now.
Hi Hootie,
For this specific issue you are encountering I would recommend to open a support ticket.
I have had this before. But not known the cause I had to keep saving and applying the excel file multiple times and then IF finally knows its been updated.
Regards,
Louie
Good to hear I’m not alone, thank you.
I will raise a ticket.
Hi @Hootie & @Promultis
By curiosity, are you processing as shown below?
I can’t reproduce your issues.
I confirm that’s the way to go and if it doesn’t behave as above, please open a ticket to Support about it.
Kind regards.
Yes, that is the way I add tabs and columns to my Excel sheets. I have also had success dropping in updated (no structure change) Excel files on top of the project file without error. I have only here recently been getting the never ending “please close Excel” when running the XP. It is hit or miss. This morning I added 2 columns to 6 sheets in an Excel AI. Composer chewed on it for what seemed like for ever, but then it seem to take. I ran the XP and any change to objects linked to the AI would pop-up the Close Excel box. I closed Composer and reopened the XP and it seems to run fine now.