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
Ken Wright - 26 Aug 2006 15:45 GMT
Only by saving a copy of the workbook (or worksheet), and then using Copy /
Paste Special as values.

Signature
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
> Can I save the excel linkage data as database ?When I need refer to
> historical data,can recall back anytime. For example,
[quoted text clipped - 13 lines]
>
> Thanks