Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Total Sales from a Database | Excel Worksheet Functions | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Links to External Database | Excel Discussion (Misc queries) | |||
The Template Wizard retains the original location for my database | Excel Discussion (Misc queries) | |||
Graphing Database Growth Rate | Charts and Charting in Excel |