ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Why can't I edit my external data sources? (https://www.excelbanter.com/links-linking-excel/19582-why-cant-i-edit-my-external-data-sources.html)

jcoburn

Why can't I edit my external data sources?
 

------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://forums.yourdomain.com.au/showthread.php?t=206693
------------------------------------------------------------------------
Question: Can you edit external data sources in Excel 2003?

- Yes
- No
- Haven't tried
- Bill strikes again
------------------------------------------------------------------------

Bill Manville Wrote:
Sounds like some sort of installation problem.

Did you keep or replace the previous version of Office when installing
2003?
What was the previous version?
If you try to create a new query from Excel 2003 specifying to edit
the
query in MSQuery at the end of the wizard, does MSQuery launch OK?

I run multiple copies of Office on my machine and about the only
problem I regularly encounter is with MSQuery where MSQuery seems not
to respond sometimes.

Have you tried running Help / Detect and Repair from Excel 2003?


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup


I was running Office 2000.

2000 was uninstalled prior to the new installation.

This problem especially occurs when I go through the pivot table
wizard, get data option, in trying to modify the underlying query.


--
jcoburn


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com