ODBC / Shared File on a network Question

Joneye

Joneye

Well-known Member
Joined
May 28, 2010
Messages
777
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
I have a file on a netowk that has an ODBC sql feed set up.

When I choose to share the file, the "REFRESH DATA" icon is shaded out - thus meaning the user can not refresh on demand.

Im using excel 2003 is there a route round this?
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

E
  • Question
Old XLSM files crashing Excel; looking for help to troubleshoot, please
Replies
9
Views
1K
jkpieterse
jkpieterse
spacecaptainsuperguy
  • Question
Advice for linked files on network drive
Replies
0
Views
359
spacecaptainsuperguy
spacecaptainsuperguy
S
  • Question
Pop Up Message Box - Out of Date items in a Column
Replies
1
Views
749
GlennUK
G
J
  • Locked
  • Question
VBA - Save As to File Location...but if Existing File is Open by Another User
Replies
4
Views
700
Fluff
Fluff
W
  • Question
Macro enable shared file mystery
Replies
2
Views
333
WIGG77
W

Forum statistics

Threads
1,215,633
Messages
6,125,928
Members
449,274
Latest member
mrcsbenson

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top