98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Databases
Databases
Resolved · Low Priority · Version 2003
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?
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Change the Default Width of All Columns in Excel 2010If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how: |
