Data Form

  • Thread starter Thread starter Vicki
  • Start date Start date
V

Vicki

I just started a new job where Data/Form is used
extensively for entering new data and searching and
updating existing records. The form is dysfunctional in
one spreadsheet: you can't add a new record or
consistently find records based on the criteria entered.
One of my coworkers says that when this happened in days
of yore, she would use a function called "reset database".
This function apparently re-identified the range of
records and the next new record for Data/Form. That
command either no longer exists or is called something
else. How can an excel dataset be corrected so that
Data/Form is useful again? Thanks for any help you can
offer.
 
The workbook may have a named range "Database" that is incorrectly
defined. To correct this:

1. Choose Insert>Name>Define
2. Select the name 'Database'
3. Change the formula in the 'Refers to' box, to match the range
on the worksheet.
4. Click OK

Or use a dynamic formula to define a range named database. There are
some instructions here:

http://www.contextures.com/xlNames01.html#Dynamic
 
Back
Top