Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Requested
Hello,
Suddenly for no reason I can fathom, Excels 'Import Data' is grayed out. It isn't on a 'new' instance of Excel, but I wish to add to an existing spreadsheet. It's not only on the current one, but on *all* my backups - even though they were ok when used previously. Can someone please explain how I might re-enable Import Data.? I really need to get this work done ! Many thanks - Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Requested
My only guess: Are the sheets are protected? I know that will block imports. -- jtp ------------------------------------------------------------------------ jtp's Profile: http://www.excelforum.com/member.php...o&userid=21132 View this thread: http://www.excelforum.com/showthread...hreadid=568587 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Requested
You may already have an import where you're trying to put a new import. When data is returned to XL, a named range is created and new queries/imports can't be created within the range - see what named ranges are on the sheet and create your new import outside of them. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Requested
Hi Ward,
I think you're onto it. It is a continuation of more imports. The Data-Import External Data - does allow "Edit Query' and 'Data Range Properties'. The latter shows one entry, If I try and delete this I'm told 'Bad Name for Query'. If I attempt changes to Data range I'm told: A query with this name already exists on this sheet or it accepts a made-up name but keeps Import grayed out. The Edit Query option shows stuff I don't understand. I can't delete it (OK becomes unavailable). I can edit it but don't know what it wants. Any further assistance would be much appreciated. Thanks - Kirk On 5 Aug 2006 08:10:57 -0700, "ward376" wrote: You may already have an import where you're trying to put a new import. When data is returned to XL, a named range is created and new queries/imports can't be created within the range - see what named ranges are on the sheet and create your new import outside of them. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Requested
If you want to add a query to a sheet with an existing query, select the existing query range using the name drop down, then select a cell outside of that range and create your new query. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula help requested | Excel Worksheet Functions | |||
sum if formula help requested | Excel Worksheet Functions | |||
A challenge, Serious help requested | New Users to Excel | |||
Help Requested on Formula | Excel Worksheet Functions | |||
Help requested regarding vba I'm having problems with. | Excel Programming |