UiPath - Pivot Table does not exist issue

Help Studio
1

Hi all,

I’m currently working on a workflow where its using the excel file and using the activity “Read Range”. When running the workflow, I get the message that the Pivot table does not exist. I stop the workflow and when I run it again, it actually completes the “Read Range” activity and pulls the desired metrics I need. I’m not sure why in the second time works, but not in the first

Context with the excel file thats being used- Its a file thats pulled from a shared file and uses the “Copy File” and “Rename File”

Any guidance would be appreciated, thank you

Here is the snippet of the error

oecmetricfeepivoterror
oecmetricfeepivoterror1201×603 33.4 KB

image
image850×1169 32.2 KB

2

Hi, @jinson.buri Try Just adding a short delay or put your Read Range inside a Retry Scope this makes sure the pivot is ready before reading and should fix the issue.

3

@jinson.buri
Looks like a sync issue..retry with a small delay would help

Also did you use excel process scope or use excel file directly?

Excel process scope properties have few settings which help in faster sync

Cheers

4

Hi @jinson.buri

Try to check in debug mode use highlight or add a breakpoint before Read range to verify if the pivot table exists in the sheet. You can also open the excel file manually during debugging to confirm the pivot table’s presence.

If helpful, mark as solution. Happy automation with UiPath

5

I don’t have the retry scope, but I did add a delay before the activity and received the same error

6

Hi, small delay was not able to resolve the issue. I use excel file directly, but I try the excel process scope and received same issue with small delay.

7

I’m not aware of debug mode as I don’t have the access to those tools. For breakpoint, are you referring to the break?

8

@jinson.buri

can you show your flow

cheers

9

Here is the flow where the excel sheet pulls from - its taken from a shared folder file.

image
image1061×1365 50.6 KB

Then here is the flow of read cell value and read range
image
image1010×1392 43.6 KB

10

@jinson.buri

if its only a copy of data what are you trying to read?

cheers