Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database ?
Hi,
Can I save the excel linkage data as database ?When I need refer to historical data,can recall back anytime. For example, In file Test.xls In sheet A, there is a form include listing. sheet 1,2,3 will retrieve data from the sheet A. Now ,I got another more set of data need to key in sheet A and link to sheet 1,2,3.But I wish to remain previous set of data and wish to keep all the data I keyed. Is that any solution to save sheet A data, and can recall anytime,for those linkage data will recall together ? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database ?
Difficult to know what you mean, but each cell can only be linked to 1
location. You can change the link, but you would have to update it. Maybe the EditLinksChange source is what you need ? NickHK "TQ" wrote in message ... Hi, Can I save the excel linkage data as database ?When I need refer to historical data,can recall back anytime. For example, In file Test.xls In sheet A, there is a form include listing. sheet 1,2,3 will retrieve data from the sheet A. Now ,I got another more set of data need to key in sheet A and link to sheet 1,2,3.But I wish to remain previous set of data and wish to keep all the data I keyed. Is that any solution to save sheet A data, and can recall anytime,for those linkage data will recall together ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row | Excel Programming |