+ Post New Thread
Results 1 to 3 of 3
Windows Thread, Link entire excel sheet to one in another book in Technical; We have one person here who updates the staff timetable and room timetable to excel sheets in her area. The ...
  1. #1

    MK-2's Avatar
    Join Date
    Oct 2006
    Location
    Nottingham
    Posts
    3,237
    Thank Post
    149
    Thanked 581 Times in 307 Posts
    Blog Entries
    8
    Rep Power
    199

    Link entire excel sheet to one in another book

    We have one person here who updates the staff timetable and room timetable to excel sheets in her area.
    The publically available staff timetable excel sheet is linked entirely to her personal one.
    I know to link one cell to one in another workbook you do
    = (click on other worksheet, click cell in there), go back to new sheet and press enter.
    But how do I link every cell in sheet 1 of say hidden.xls to every cell in sheet 1 of public.xls, so when she updates hidden.xls it updates public.xls

    Sorry if I haven't made that sound clear, I know what I mean in my head, it's just explaining it

  2. #2

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,568 Times in 1,250 Posts
    Rep Power
    340
    I know what you're getting at, but wouldn't it be just as well she copied and pasted the updated spreadsheet into the public area?

  3. #3
    DrPerceptron's Avatar
    Join Date
    Dec 2008
    Location
    In a house
    Posts
    917
    Thank Post
    34
    Thanked 134 Times in 114 Posts
    Rep Power
    41
    Why not set security on it so everyone can read, but she can also write to it...

    I'm pretty sure you link spreadsheets in the same way, just in square brackets you have the file name. You probably have to allow everyone access to read the hidden file in its current location...

    In which case, a single read-only file would be better...

SHARE:
+ Post New Thread

Similar Threads

  1. DT Assessment sheet.
    By rush_tech in forum How do you do....it?
    Replies: 1
    Last Post: 23rd June 2008, 09:11 AM
  2. How to link a component to admin control quick link icons box
    By DirtySnipe in forum EduGeek Joomla 1.5 Package
    Replies: 1
    Last Post: 15th June 2008, 08:02 PM
  3. KompoZer - style sheet
    By speckytecky in forum Web Development
    Replies: 0
    Last Post: 22nd April 2008, 08:39 PM
  4. Replies: 5
    Last Post: 11th December 2007, 10:44 AM
  5. Copy entire laptop HDD
    By DSapseid in forum Hardware
    Replies: 5
    Last Post: 16th October 2007, 02:34 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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