In FP2002, doing the Insert,Database,Results and using
the database Wizard to do a database connection to an
Excel Spreadsheet. Get an error from the D/B Wizard:


Error: The excel file referenced by this database
connection does not contain a named range of cells that
the database driver recognizes as a database table. See
Excel to name a range of cells.

In Excel, I followed all their instructions to name cells
but nothing changes...always get the same error.

Can someone help?? Thank You.

I think you would get a better answer if you posted this to the Excel
newsgroup (microsoft.public.excel).

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big Things are made up of
Lots of Little Things.

"Mary Jane" <(E-Mail Removed)> wrote in message
news:0c3301c397ea$90a26890$(E-Mail Removed)...
> In FP2002, doing the Insert,Database,Results and using
> the database Wizard to do a database connection to an
> Excel Spreadsheet. Get an error from the D/B Wizard:
>
>
> Error: The excel file referenced by this database
> connection does not contain a named range of cells that
> the database driver recognizes as a database table. See
> Excel to name a range of cells.
>
> In Excel, I followed all their instructions to name cells
> but nothing changes...always get the same error.
>
> Can someone help?? Thank You.

Mary Jane:
Are these the instructions you followed? HOW TO: Use an Excel Worksheet as
a Data Source in FrontPage 2000 http://support.microsoft.com/?kbid=268948


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


Mary Jane <(E-Mail Removed)> wrote:
> In FP2002, doing the Insert,Database,Results and using
> the database Wizard to do a database connection to an
> Excel Spreadsheet. Get an error from the D/B Wizard:
>
>
> Error: The excel file referenced by this database
> connection does not contain a named range of cells that
> the database driver recognizes as a database table. See
> Excel to name a range of cells.
>
> In Excel, I followed all their instructions to name cells
> but nothing changes...always get the same error.
>
> Can someone help?? Thank You.

>-----Original Message-----
>Mary Jane:
>Are these the instructions you followed? HOW TO: Use an
Excel Worksheet as
>a Data Source in FrontPage 2000
http://support.microsoft.com/?kbid=268948
>
>
>--
>~ Kathleen Anderson
>Microsoft MVP - FrontPage
>Spider Web Woman Designs
>http://www.spiderwebwoman.com/resources/


I will try these instructions. The ones I tried to
follow were the ones I found in the Help of Excel and
they seem to be a little short on specifics. Thank You.>
>
>Mary Jane <(E-Mail Removed)> wrote:
>> In FP2002, doing the Insert,Database,Results and using
>> the database Wizard to do a database connection to an
>> Excel Spreadsheet. Get an error from the D/B Wizard:
>>
>>
>> Error: The excel file referenced by this database
>> connection does not contain a named range of cells that
>> the database driver recognizes as a database table.
See
>> Excel to name a range of cells.
>>
>> In Excel, I followed all their instructions to name
cells
>> but nothing changes...always get the same error.
>>
>> Can someone help?? Thank You.
>
>
>.
>

>-----Original Message-----
>In FP2002, doing the Insert,Database,Results and using
>the database Wizard to do a database connection to an
>Excel Spreadsheet. Get an error from the D/B Wizard:
>
>
>Error: The excel file referenced by this database
>connection does not contain a named range of cells that
>the database driver recognizes as a database table. See
>Excel to name a range of cells.
>
>In Excel, I followed all their instructions to name
cells
>but nothing changes...always get the same error.

The KB article #268948 worked like a charm...thank you.
>
>Can someone help?? Thank You.
>.
>

You're welcome! Thanks for letting us know :-)

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


(E-Mail Removed) wrote:
>> -----Original Message-----
>> In FP2002, doing the Insert,Database,Results and using
>> the database Wizard to do a database connection to an
>> Excel Spreadsheet. Get an error from the D/B Wizard:
>>
>>
>> Error: The excel file referenced by this database
>> connection does not contain a named range of cells that
>> the database driver recognizes as a database table. See
>> Excel to name a range of cells.
>>
>> In Excel, I followed all their instructions to name cells
>> but nothing changes...always get the same error.
>
> The KB article #268948 worked like a charm...thank you.
>>
>> Can someone help?? Thank You.
>> .