Office 365 excel file locked for editing by me
elelator-go-up.elelator-go-down wheeeeeeee This will allow you to open the database and make changes to the information that may not show up in the worksheet until the refresh.
Refresh once on the worksheet level (not really needed. "Mode=Share Deny None" Close back to the Connections manager dialog.
Search thru the string until you find something like this (if the database says you can't make changes then:) "Mode=Share Deny Write" or (if you are told the database is already in use:) "Mode=Share Deny Read|Share Deny Write" Now be careful here. The connection string is like the registry. Ribbon>Data>Connections In the dialog box select the connection and then Now in the tab This is the pain. What you need to do (in office 2010): Close the related database and Access otherwise changes will not take. This is due to the fact normally the data isn't set up to refresh automatically. it opens the database in exclusive mode by default. This has to do with how the connection was made in EXCEL. System Database=False Jet OLEDB:Encrypt Database=False Jet OLEDB:Don't Copy Locale on Compact=False Jet OLEDB:Compact Without Replica Repair=False Jet OLEDB:SFP=False Jet OLEDB:Support Complex Data=False Jet OLEDB:Bypass UserInfo Validation=False OLEDB:System database="" Jet OLEDB:Registry Path="" Jet OLEDB:Engine Type=6 Jet OLEDB:Database Locking Mode=0 Jet OLEDB:Global Partial Bulk Ops=2 Jet OLEDB:Global Bulk Transactions=1 Jet OLEDB:New Database Password="" Jet OLEDB:Create Provider=.12.0 User ID=Admin Data Source=S:\Corporate Actions\CA TIMELINE DATABASE\CA Timelines DatabaseBE -V3.accdb Mode=Share Deny Write Extended Properties="" Jet Does this mean i need to change the connection string to Mode=Share Deny None?