Excel Connected to a Server - long time wait

[Pammelosidad]

Hi,

I have an Excel file connected to an Azure Server, It lets me create pivot tables, however when I try to update for results it takes a very long time and seems it is loading but at the end I get error messages such "Operation Cancelled due to locking conflicts" Not sure how can I fix it.

 

[mole999]

what is you SQL, you can add things like NOLOCK to script to ignore looking, I would think it could be related to numerous updates being done on the data and that would leave parts open.