Using the newest excel (2007?). It is in compatibility mode (.xls)
My entire "Get External Data" field is grayed out and unusable. This field is under the "Data" tab.
How do I get this to work. Any help would be wonderfully appreciated.
BTW: It wasn't grayed out yesterday!!
I figured it out. I could only import 1 set of external data for the worksheet. Once I cleared the old external data, the "get external data" icons were no longer grayed out.
This doesn't tell us exactly what is locking the rows/cells. I am experiencing a similar problem and know that I could get your solution to work. But that won't suit my situation. Does anyone else have additional information to impart to this issue?
notwhereuareat,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks