A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Database or list range is not valid



 
 
Thread Tools Display Modes
  #1  
Old December 15th 04, 09:15 PM
JRM
external usenet poster
 
Posts: n/a
Default Database or list range is not valid

I'm exporting a rather simple table to Excel and when I attempt to use an
Excel form against the imported spreadsheet (from the menu, Data | Form), I
receive the error "Database or list range is not valid."

I cannot figure out what changes to make to make it "valid". I compare the
characteristics of the imported spreadsheet to other sheets in the workbook
that do work with the form but cannot figure out what is wrong.

The table has not strange columns like binaries and is only 40 or 50 rows
deep, has column headers, is only 16 columns wide.

Regards,

James Mireles,
Houston, TX
Ads
  #2  
Old December 16th 04, 01:03 AM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default

Is there a range named "Database" (to see, choose Insert>Name>Define)?
If so, perhaps it's broken, and the Data Form can't open correctly.

Try deleting the name, to see if that prevents the error from occurring.


JRM wrote:
> I'm exporting a rather simple table to Excel and when I attempt to use an
> Excel form against the imported spreadsheet (from the menu, Data | Form), I
> receive the error "Database or list range is not valid."
>
> I cannot figure out what changes to make to make it "valid". I compare the
> characteristics of the imported spreadsheet to other sheets in the workbook
> that do work with the form but cannot figure out what is wrong.
>
> The table has not strange columns like binaries and is only 40 or 50 rows
> deep, has column headers, is only 16 columns wide.
>
> Regards,
>
> James Mireles,
> Houston, TX



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3  
Old December 16th 04, 01:29 AM
JRM
external usenet poster
 
Posts: n/a
Default

Thanks Debra,

I did try just that with no success.

I found a "solution" of sorts.

When the table is exported into Excel it comes in as a worksheet where the
columns are of equal size. Resizing the columns "fixed" whatever was broken
that kept Excel from recognizing the worksheet as a table. That's all I had
to do: Select all columns and double-click a column divider to autosize their
column widths to fit contents.

Presto. The Data | Form feature works.

The Excel BOL does say that Excel needs to be able to recognize a row of
header and a row of data. Apparently Excel was unable to recognize the table
until the columns were adjusted.

I'll probably modify my export VBA to run the AutoFit method on the
newly-imported worksheet so I don't have to re-open the spreadsheet and do
that manually. (When exported the worksheet's contents are given a range name
identical to the worksheet name.)

Thanks.

Regards,

James Mireles
Houston, TX

"Debra Dalgleish" wrote:

> Is there a range named "Database" (to see, choose Insert>Name>Define)?
> If so, perhaps it's broken, and the Data Form can't open correctly.
>
> Try deleting the name, to see if that prevents the error from occurring.
>
>
> JRM wrote:
> > I'm exporting a rather simple table to Excel and when I attempt to use an
> > Excel form against the imported spreadsheet (from the menu, Data | Form), I
> > receive the error "Database or list range is not valid."
> >
> > I cannot figure out what changes to make to make it "valid". I compare the
> > characteristics of the imported spreadsheet to other sheets in the workbook
> > that do work with the form but cannot figure out what is wrong.
> >
> > The table has not strange columns like binaries and is only 40 or 50 rows
> > deep, has column headers, is only 16 columns wide.
> >
> > Regards,
> >
> > James Mireles,
> > Houston, TX

>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 02:48 PM
How do I create a "List If" function.I need to search a database . Flying Solo Excel Worksheet Functions 2 December 7th 04 04:44 PM
I have a list of dates that I need to count based on a date range ejb030353 Excel Worksheet Functions 4 November 24th 04 03:27 PM
How can I sum information in a list with a date range? Dave Excel Worksheet Functions 2 November 23rd 04 09:17 PM
Creating a list from an existing list. Jad Excel Worksheet Functions 1 October 29th 04 06:00 AM


All times are GMT +1. The time now is 09:14 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.