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

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