Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Link data with different workbooks

  1. #1
    Guest

    Default

    Hi Excellers:
    I have Main.xls which has various customers information.
    I have 1001.xls to 1500.xls workbook (about 500 customers workbook, information are save base on customer company code)which summaries information of customers from Main.xls.

    Example of Main.xls:
    A B C D
    1 Co. code Co. name Address Year end
    2 1001 A Ltd No.1Road 31/12/02
    3 1002 B Ltd No.2Road 31/8/01
    4 1003 C Ltd No.3Road 31/10/01
    5 1005 D Ltd No.4Road 31/12/02
    up to
    1500

    Example of 1001.xls :
    A B
    1 Co. code 1001
    2 Co. name A Ltd
    3 Address No. 1 Road
    4 Year end 31/12/02

    The data currently are update weekly due to change of customers information. The volume of data is about 5mb.
    If anyone can tell me how to keep this link alive this would be greatly helpful.

    Thanks in advance.



  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    so what's happening to the links now, that they'not being retained? i guess it's happening when the dependent sheets get updated(?), but as far as i know any external references in the 'main' workbook should be retained. do the updates have the same area (ie range of cells)? have you tried F9 after an update? not trying to be smart with all the questions - just looking for some more information.

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Malaysia
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Layout for Main.xls:
    A B C D
    1 Co. code Co. name Address Year end
    2 1001 A Ltd No.1Road 31/12/02
    3 1002 B Ltd No.2Road 31/8/01
    4 1003 C Ltd No.3Road 31/10/01
    5 1005 D Ltd No.4Road 31/12/02

    Layout for 1001.xls and other customer file are:

    A B
    1 Co. code 1001
    2 Co. name A Ltd
    3 Address No. 1 Road
    4 Year end 31/12/02

    The frequent update area is at B1 to B4, which is dependent information from Main.xls.
    Can anyone please help me in this?
    Thank you.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •