Results 1 to 14 of 14

Thread: Excel Help

  1. #1
    Rookie
    Points: 11,982, Level: 33
    Level completed: 5%, Points required for next Level: 668
    Overall activity: 0%
    Achievements:
    Veteran10000 Experience Points
    Cymaster's Avatar
    Join Date
    Jun 2006
    Posts
    483
    Points
    11,982
    Level
    33
    Thumbs Up
    Received: 0
    Given: 0

    Excel Help

    I love having a legitimate excuse to be on CF during work

    So a coworker has an excel file on her hard drive as a master, and has copied it to a shared drive for others to see. She would like to be able to save her master file, and have the copied file update automatically. I remember doing this relatively simply before, but I can't, for the life of me, figure out how I did it.


    "I'm starting to think some Iowa fans heads are getting too big." -- Tigerhawk22

  2. #2
    Speechless
    Points: 432,882, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 4.0%
    Achievements:
    SocialRecommendation Second ClassVeteranCreated Album pictures50000 Experience Points

    Join Date
    Nov 2007
    Location
    Ames
    Posts
    23,820
    Points
    432,882
    Level
    100
    Thumbs Up
    Received: 124
    Given: 17

    Re: Excel Help

    Set up the copy on the shared drive as a shortcut?



  3. #3
    Speechless
    Points: 335,469, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 0%
    Achievements:
    SocialVeteran50000 Experience Points
    ISUFan22's Avatar
    Join Date
    Apr 2006
    Location
    Grimes, IA
    Posts
    31,736
    Points
    335,469
    Level
    100
    Thumbs Up
    Received: 74
    Given: 162

    Re: Excel Help

    Quote Originally Posted by IcSyU View Post
    Set up the copy on the shared drive as a shortcut?
    Issue with this may be others could "accidentally" edit the file, which it seems is not something she wants.

    I have not done something like this. Sharepoint is a good way to do it (or another intranet).



  4. #4
    Rookie
    Points: 11,982, Level: 33
    Level completed: 5%, Points required for next Level: 668
    Overall activity: 0%
    Achievements:
    Veteran10000 Experience Points
    Cymaster's Avatar
    Join Date
    Jun 2006
    Posts
    483
    Points
    11,982
    Level
    33
    Thumbs Up
    Received: 0
    Given: 0

    Re: Excel Help

    Quote Originally Posted by IcSyU View Post
    Set up the copy on the shared drive as a shortcut?
    She tried that, but other people couldn't open it.


    "I'm starting to think some Iowa fans heads are getting too big." -- Tigerhawk22

  5. #5
    Addict
    Points: 165,941, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 4.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    jaretac's Avatar
    Join Date
    Nov 2006
    Location
    Frigidaire
    Posts
    7,634
    Points
    165,941
    Level
    100
    Thumbs Up
    Received: 2
    Given: 0

    Re: Excel Help

    password protect it



  6. #6
    Speechless
    Points: 432,882, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 4.0%
    Achievements:
    SocialRecommendation Second ClassVeteranCreated Album pictures50000 Experience Points

    Join Date
    Nov 2007
    Location
    Ames
    Posts
    23,820
    Points
    432,882
    Level
    100
    Thumbs Up
    Received: 124
    Given: 17

    Re: Excel Help

    Quote Originally Posted by Cymaster View Post
    She tried that, but other people couldn't open it.
    Try and put the master file on the main server for people to see, but password protect either sheets or the entire workbook that are important. Then link the copy from her hard drive to the server. She'd just have to edit the file on the main server, but the one on her hard drive should automatically update.



  7. #7
    All-Star
    Points: 24,557, Level: 48
    Level completed: 1%, Points required for next Level: 993
    Overall activity: 2.0%
    Achievements:
    SocialVeteran10000 Experience Points
    isugcs's Avatar
    Join Date
    Feb 2007
    Location
    Waverly
    Posts
    1,593
    Points
    24,557
    Level
    48
    Thumbs Up
    Received: 1
    Given: 31

    Re: Excel Help

    I'd like to turn this into an Excel Appreciation Thread. Does anyone else simply love all the wonderful things you can do with excel?? I use excel everyday for various tasks and I am still learning new things. Anyone else agree?



  8. #8
    Rookie
    Points: 11,982, Level: 33
    Level completed: 5%, Points required for next Level: 668
    Overall activity: 0%
    Achievements:
    Veteran10000 Experience Points
    Cymaster's Avatar
    Join Date
    Jun 2006
    Posts
    483
    Points
    11,982
    Level
    33
    Thumbs Up
    Received: 0
    Given: 0

    Re: Excel Help

    Quote Originally Posted by isugcs View Post
    I'd like to turn this into an Excel Appreciation Thread. Does anyone else simply love all the wonderful things you can do with excel?? I use excel everyday for various tasks and I am still learning new things. Anyone else agree?
    Normally I don't like thread hijacking. But, this one I can get on board with


    "I'm starting to think some Iowa fans heads are getting too big." -- Tigerhawk22

  9. #9
    Swarm & Punish
    Points: 285,342, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 42.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    19,682
    Points
    285,342
    Level
    100
    Thumbs Up
    Received: 379
    Given: 678
    The first and best victory is to conquer self; to be conquered by self is of all things most shameful and vile. - Plato

    May you only need 39 acres to turn your rig around. - keep

  10. #10
    Starter
    Points: 17,503, Level: 40
    Level completed: 32%, Points required for next Level: 547
    Overall activity: 0%
    Achievements:
    Veteran10000 Experience Points

    Join Date
    Jan 2009
    Posts
    663
    Points
    17,503
    Level
    40
    Thumbs Up
    Received: 11
    Given: 4

    Re: Excel Help

    I would save it to the shared drive, but password protect it so only she (or anyone else with the password) can modify it.

    Click File, Save as, tools, general options, and put a password in the "Password to modify" box.



  11. #11
    Addict
    Points: 131,226, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 16.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    cyrevkah's Avatar
    Join Date
    Apr 2008
    Location
    Ames, IA
    Posts
    7,137
    Points
    131,226
    Level
    100
    Thumbs Up
    Received: 116
    Given: 529

    Re: Excel Help

    I only do really basic things with excel, but apprently that's more than those that test at the local Office Team. They told me I had the highest score from their location......

    I finally learned what a macro is......



  12. #12
    Addict
    Points: 131,226, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 16.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    cyrevkah's Avatar
    Join Date
    Apr 2008
    Location
    Ames, IA
    Posts
    7,137
    Points
    131,226
    Level
    100
    Thumbs Up
    Received: 116
    Given: 529

    Re: Excel Help

    Now, I'm making excel files for my Ann. Report progress and Summer camp issues!



  13. #13
    Addict
    Points: 165,941, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 4.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    jaretac's Avatar
    Join Date
    Nov 2006
    Location
    Frigidaire
    Posts
    7,634
    Points
    165,941
    Level
    100
    Thumbs Up
    Received: 2
    Given: 0

    Re: Excel Help

    Quote Originally Posted by isugcs View Post
    I'd like to turn this into an Excel Appreciation Thread. Does anyone else simply love all the wonderful things you can do with excel?? I use excel everyday for various tasks and I am still learning new things. Anyone else agree?
    I hate excel, and I can provide a spreadsheet with all the reasons why.


    Last edited by jaretac; 03-20-2009 at 04:25 PM.

  14. #14
    Pro
    Points: 38,957, Level: 60
    Level completed: 93%, Points required for next Level: 93
    Overall activity: 19.0%
    Achievements:
    SocialVeteranCreated Album pictures25000 Experience Points

    Join Date
    May 2008
    Location
    Ames
    Posts
    2,953
    Points
    38,957
    Level
    60
    Thumbs Up
    Received: 33
    Given: 12

    Re: Excel Help

    Quote Originally Posted by cyrevkah View Post
    Now, I'm making excel files for my Ann. Report progress and Summer camp issues!
    Remember to make colorful charts and graphs, too. The more colors the better.
    j/k



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • TV: Fox Sports 1
  • Iowa State vs. North Dakota State
  • August 30, 2014
  • 11:00 AM