Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Excel question

  1. #1
    Member Muppet's Avatar
    Join Date
    Jan 2014
    Posts
    96
    vCash
    2756
    Points
    92,620
    Bank
    0
    Total Points
    92,620
    Donate

    Excel question

    Hey Guys,.

    Not sure where to post this. Google didn't help.

    A while back, one of my users f
    not so blue

  2. #2
    Senior Member CeeBee's Avatar
    Join Date
    Jan 2014
    Posts
    1,662
    vCash
    1792
    Points
    85,404
    Bank
    0
    Total Points
    85,404
    Donate
    Actually it's very simple.
    Just f

  3. #3
    Senior Member Webhead's Avatar
    Join Date
    Jan 2014
    Posts
    1,829
    vCash
    500
    Points
    385,151
    Bank
    0
    Total Points
    385,151
    Donate
    It's almost like the phone call just disconnected in mid sentence.

  4. #4
    Senior Member
    Join Date
    Jan 2014
    Posts
    1,321
    vCash
    0
    Points
    211,080
    Bank
    0
    Total Points
    211,080
    Donate
    the answer is 42

  5. #5
    Senior Member Webhead's Avatar
    Join Date
    Jan 2014
    Posts
    1,829
    vCash
    500
    Points
    385,151
    Bank
    0
    Total Points
    385,151
    Donate
    The other day the phone rang and so I answered it and t

  6. #6
    Member Muppet's Avatar
    Join Date
    Jan 2014
    Posts
    96
    vCash
    2756
    Points
    92,620
    Bank
    0
    Total Points
    92,620
    Donate
    hrmmhhh.. No idea what happened to the Original Post. I typed the whole thing. odd

    anyway, She messed up a very large departmental spreadsheet so a couple hundred hyperlinks were re-directed to her local data folder rather than the network share. I fixed it by creating a custom macro (several times) to restore the broken links. I had to do this for numerous file paths.

    Ever since I did this, my Excel on my laptop is messed up. Whenever I open any spreadsheet, a second workbook, name "Personal", opens up. I think this "personal" book is the original macro or something. I've tried everything I can think of and tinker with to stop this behavior to no avail. I am not overly skilled in Excel and am kinda hoping one of you can shed some light on this issue. Google was no help.


    Thanks
    not so blue

  7. #7
    Senior Member CeeBee's Avatar
    Join Date
    Jan 2014
    Posts
    1,662
    vCash
    1792
    Points
    85,404
    Bank
    0
    Total Points
    85,404
    Donate
    Close Excel, kill any running process.
    Look for .xlb and .xlt files under your profile.
    Back them up for safety and delete them.

  8. #8
    Member Muppet's Avatar
    Join Date
    Jan 2014
    Posts
    96
    vCash
    2756
    Points
    92,620
    Bank
    0
    Total Points
    92,620
    Donate
    no luck. thanks for trying
    not so blue

  9. #9
    Senior Member CeeBee's Avatar
    Join Date
    Jan 2014
    Posts
    1,662
    vCash
    1792
    Points
    85,404
    Bank
    0
    Total Points
    85,404
    Donate
    Also look for .xltx, .xltm
    Those are the templates.

  10. #10
    Administrator
    Join Date
    Jan 2014
    Posts
    101
    vCash
    500
    Points
    94,349
    Bank
    0
    Total Points
    94,349
    Donate
    Also go to permissions and stop macros running, look for my templates and check for the path - you might have the wrong path now.

Posting Permissions

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