Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do linked worksheets exist with data on an external device
I have a destination worksheet that is linked and updated from a source
workbook (my original). I did this with copy range paste special paste link. this works fine if only on one computer. As I understand that this allows only the data on the destination file to exist through the link to the source file. If I want the destination file to copy and export to a handheld device I lose the data due to the link. I cannot open it in the device when it is a linked document. I can when it is a manual copy of the source or destination file without links. But this does not update and adjustments unless manually copied at the end of each session. How do I automat the adjustments on the source file to the destination file without links. So I can copy and move to the device? I basically have 3 files. 1x Master Source wKbook, linked or copied to a `lite' single wksheet destination file, which I want to update any adjustments I make in the source Wkbook file. Then I am happy to manually copy and paste the destination wksheet to a handheld device. I can open a direct copy of the source or destination file on the device so I know eXl is supported. But the linked destination file does not open. The handheld device does not need to sync back to the source.It is a reference only. Thankyou for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Protected EXCEL worksheets to update linked data | Links and Linking in Excel | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Unique and duplicate data between 2 Excel worksheets | Excel Worksheet Functions | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) |