While reading the second large excel and writing the large excel i’m getting error.
You aren’t reading, you’re writing. Did you unhide the hidden rows?
yes thanks for correcting it, no i haven’t done that
When hidden rows are present or when filters are on it might give this error as it states..first clear all of them before writing
Cheers
lets say we have 13 reports to download in for each row loop, if i put terminate work flow after downloading single report and downloading single report works fine, but if i loop that 13 reports all together then I’m getting this error, so it seems weird for me.
Hello @Sathish_Kumar5
Could you try with this setup to clear any filter before writing to the file.
Regards
Soren
1 Like
Can you show your workflow please…that would give more clarity
are you doing any manipulations or filters inside it?
cheers
1 Like
So then you should probably do what the error message says to do, and test it again.
1 Like
sorry i couldn’t show the workflow, but we are writing the same data to same excel file and invoking vba file and looping continues. thanks for your support.
1 Like
yes it will work on the second run, but for the first run. its not required, i’m just trying to understand why the error comes when we approach in continous loop
sure thanks for the response @postwick
If its same file better keep the scope outside loop
Or use excel process scope outside loop and inside loop use excel file(only if file is different)
If same file keep use excel file around for loop
Cheers
Can you show the complete exception message from local tab.
Questions ?
What actions does INVOKE VBA perform?
- Is it apply any filter or manipulating the data?
Where is the file hosted? Local or sharepoint folders?
I would suspect the VBA part has something to do with it.
But hard to say if you are unable to share the code.
Leaving the Filter activity at the top with the Clear any existing filter will hopefully fix the error and should’nt be a problem even if no filter is set.
Regards
Soren