1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved Missing Link

Discussion in 'Business Applications' started by Robm1955, Oct 15, 2019.

Thread Status:
Not open for further replies.
Advertisement
  1. Robm1955

    Robm1955 Thread Starter

    Joined:
    Apr 28, 2009
    Messages:
    335
    Over a year ago, when I was working, I used a spreadsheet I had created, for recording holidays. This took into account, working days, and weekends. I had this on a USB stick. I want to access it again, but when it asks if I want to update the links (which are only on another tab), it says that atpvbaen.xls is missing. I recall, that this is part of Microsoft Office, but I don't know where to find it, or where it should be located for my spreadsheet to find it.
     
  2. Fireflycph

    Fireflycph

    Joined:
    Apr 1, 2016
    Messages:
    1,154
    First Name:
    Morten
    I believe that is part of the VBA analysis toolpack. It needs to be installed/enabled.

    Which version of Excel are you using?
     
    Last edited: Oct 16, 2019
  3. Robm1955

    Robm1955 Thread Starter

    Joined:
    Apr 28, 2009
    Messages:
    335
    Version 2003. I remembered how to setup the Analysis Toolpak. I have to find my disc now, as it says it's not installed.
     
    Last edited: Oct 16, 2019
  4. Fireflycph

    Fireflycph

    Joined:
    Apr 1, 2016
    Messages:
    1,154
    First Name:
    Morten
    I found THIS. Not sure whether it'll work or not. Version 2003 is a bit before my limited experience.
     
  5. Robm1955

    Robm1955 Thread Starter

    Joined:
    Apr 28, 2009
    Messages:
    335
    Thanks Fireflycph. It does help, but I still needed to find my cd, which I did. Installed the Analysis Toolkit, which must install the file I was missing. All's good. Thanks to you both for your assistance.
     
  6. Fireflycph

    Fireflycph

    Joined:
    Apr 1, 2016
    Messages:
    1,154
    First Name:
    Morten
    Glad you got it solved.

    Please mark the thread as "solved" if all is ok.
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1234291

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice