Results 1 to 14 of 14

Thread: Excel Help

  1. #1
    Rookie
    Points: 12,743, Level: 34
    Level completed: 14%, Points required for next Level: 607
    Overall activity: 1.0%
    Achievements:
    Veteran10000 Experience Points
    Cymaster's Avatar
    Join Date
    Jun 2006
    Posts
    486
    Points
    12,743
    Level
    34
    Thumbs Up
    Received: 0
    Given: 1

    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: 449,291, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 6.0%
    Achievements:
    SocialRecommendation Second ClassVeteranCreated Album pictures50000 Experience Points

    Join Date
    Nov 2007
    Location
    Rochester, MN
    Posts
    24,693
    Points
    449,291
    Level
    100
    Thumbs Up
    Received: 663
    Given: 225

    Re: Excel Help

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



  3. #3
    Speechless
    Points: 358,762, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 7.0%
    Achievements:
    SocialVeteran50000 Experience Points
    ISUFan22's Avatar
    Join Date
    Apr 2006
    Location
    Denver, CO
    Posts
    33,603
    Points
    358,762
    Level
    100
    Thumbs Up
    Received: 1,265
    Given: 668

    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: 12,743, Level: 34
    Level completed: 14%, Points required for next Level: 607
    Overall activity: 1.0%
    Achievements:
    Veteran10000 Experience Points
    Cymaster's Avatar
    Join Date
    Jun 2006
    Posts
    486
    Points
    12,743
    Level
    34
    Thumbs Up
    Received: 0
    Given: 1

    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: 150,228, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    jaretac's Avatar
    Join Date
    Nov 2006
    Location
    Frigidaire
    Posts
    7,644
    Points
    150,228
    Level
    100
    Thumbs Up
    Received: 5
    Given: 0

    Re: Excel Help

    password protect it



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

    Join Date
    Nov 2007
    Location
    Rochester, MN
    Posts
    24,693
    Points
    449,291
    Level
    100
    Thumbs Up
    Received: 663
    Given: 225

    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: 28,754, Level: 52
    Level completed: 10%, Points required for next Level: 996
    Overall activity: 0%
    Achievements:
    SocialVeteran25000 Experience Points
    isugcs's Avatar
    Join Date
    Feb 2007
    Location
    Waverly
    Posts
    1,630
    Points
    28,754
    Level
    52
    Thumbs Up
    Received: 13
    Given: 328

    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: 12,743, Level: 34
    Level completed: 14%, Points required for next Level: 607
    Overall activity: 1.0%
    Achievements:
    Veteran10000 Experience Points
    Cymaster's Avatar
    Join Date
    Jun 2006
    Posts
    486
    Points
    12,743
    Level
    34
    Thumbs Up
    Received: 0
    Given: 1

    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: 326,238, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 10.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    22,282
    Points
    326,238
    Level
    100
    Thumbs Up
    Received: 1,994
    Given: 4,756
    This post is pending approval of site sponsors.

  10. #10
    Starter
    Points: 18,742, Level: 41
    Level completed: 77%, Points required for next Level: 208
    Overall activity: 0%
    Achievements:
    Veteran10000 Experience Points

    Join Date
    Jan 2009
    Posts
    702
    Points
    18,742
    Level
    41
    Thumbs Up
    Received: 31
    Given: 17

    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: 171,338, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 11.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    cyrevkah's Avatar
    Join Date
    Apr 2008
    Location
    Ames, IA
    Posts
    8,715
    Points
    171,338
    Level
    100
    Thumbs Up
    Received: 851
    Given: 4,577

    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: 171,338, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 11.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    cyrevkah's Avatar
    Join Date
    Apr 2008
    Location
    Ames, IA
    Posts
    8,715
    Points
    171,338
    Level
    100
    Thumbs Up
    Received: 851
    Given: 4,577

    Re: Excel Help

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



  13. #13
    Addict
    Points: 150,228, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    jaretac's Avatar
    Join Date
    Nov 2006
    Location
    Frigidaire
    Posts
    7,644
    Points
    150,228
    Level
    100
    Thumbs Up
    Received: 5
    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 05:25 PM.

  14. #14
    Pro
    Points: 50,246, Level: 69
    Level completed: 36%, Points required for next Level: 904
    Overall activity: 9.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points

    Join Date
    May 2008
    Location
    Ames
    Posts
    3,375
    Points
    50,246
    Level
    69
    Thumbs Up
    Received: 135
    Given: 94

    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: ESPN
  • HOOPS: Iowa State vs. Texas
  • February 13, 2016
  • 07:30 PM