If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Database ?
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
|
|||
|
|||
Database ?
Only by saving a copy of the workbook (or worksheet), and then using Copy /
Paste Special as values. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "TQ" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|