Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Databases

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Databases

Resolved · Low Priority · Version 2003

Reply Wed 20 Aug 2008, 17:00Delegate Reeja said...

Reeja has attended:
Excel Advanced course
Access Introduction course

Databases

how do you create a database that can be refreshed/updated with new data?

For upcoming training course dates see: Pricing & availability

Reply Thu 11 Sep 2008, 14:54Trainer Alan said...

RE: databases

Hi Reeja

You need to construct a pivot table from your source data. When the source data changes you can update the pivottable with the REFRESH DATA command. The pivottable will then change and reanalyse the new data.

If your database comes from several spreadsheets, you could use the Data Consolidate command to take the data from the source sheets and total it. When your source sheets change, the same command will refresh the database.

Good luck!

Alan Burbridge

Excel articles

· How To Create Formulas In Excel
· Excel 2010 A Glance Into The Future
· How To Disguise Error Messages In Excel 2007/2010
· How to start using Excel 2007 Functions
· MS Excel: Excel At Making The Most Of Your Christmas

Please browse our web site to find out more about
microsoft excel training and other Microsoft training courses.

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips