Source Data is Locked when using Connection File (even after readonly is specified)

I am using Excel 2013 and I created an excel data file on a shared drive. I created a connection file (using data connection wizard in excel) to pull that data into a pivot table. This pivot is working great for me, but I want to scale this up for multiple users. However, my source data is locked up when the first person refreshes the pivot table. So I can no longer update the source data until that user closes the destination pivot table. I tried Mode=Read and ReadOnly=True, but it the source data is still getting locked up. What am I missing?

Provider=MSDASQL.1;Persist Security Info=False;Data Source=Excel Files;Mode=Read;ReadOnly=True;Extended Properties="DSN=Excel Files;DBQ=R:\TRANSFER\Pegging Reports\Pegging strategy\Pegging Cube.xlsx;DefaultDir=R:\TRANSFER\Pegging Reports\Pegging strategy;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;";Initial Catalog=R:\TRANSFER\Pegging Reports\Pegging strategy\Pegging Cube.xlsx Table R:\TRANSFER\Pegging Reports\Pegging strategy\Pegging Cube.xlsx.'Pegging Cube$'

0
edit delete
are you sure?
asked Brad McFadden

1 answer

Want to Know snapchat ghost faces meaning? Snapchat has many different Ghost faces available

0
edit delete
are you sure?
answered Lynette Spicer

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions