Panderson34342
New member
- Local time
- Today, 10:51
- Joined
- Mar 24, 2014
- Messages
- 1
Hello!
I am attempting to link a database file with an excel spreadsheet and have come across a small problem.
When I first link the database to the excel spreadsheet all the information moves across nicely. Actually very impressed with it!
I then use this information, with a series of look-up commands, to make some results tables.
My problem is when I go back and add new information to database and refresh the spreadsheet. Now what happens is I find my formulae are written over, for example:
Before
*****
A1: ='tab'!A1
A2: ='tab'!A2
A3: ='tab'!A3
After (adding in one more line of data in database)
**************************************
A1: ='tab'!A1
A2: ='tab'!A2
A3: ='tab'!A4
I should be seeing 4 rows but the last one is overwritten instead. Note that I have 1000 rows to allow for varying amounts of data.
Why is this happening!
All help will be greatly appreciated.
Regards,
Peter
I am attempting to link a database file with an excel spreadsheet and have come across a small problem.
When I first link the database to the excel spreadsheet all the information moves across nicely. Actually very impressed with it!
I then use this information, with a series of look-up commands, to make some results tables.
My problem is when I go back and add new information to database and refresh the spreadsheet. Now what happens is I find my formulae are written over, for example:
Before
*****
A1: ='tab'!A1
A2: ='tab'!A2
A3: ='tab'!A3
After (adding in one more line of data in database)
**************************************
A1: ='tab'!A1
A2: ='tab'!A2
A3: ='tab'!A4
I should be seeing 4 rows but the last one is overwritten instead. Note that I have 1000 rows to allow for varying amounts of data.
Why is this happening!
All help will be greatly appreciated.
Regards,
Peter
