Solved

Excel Start Up Macro

Posted on 2016-07-16
8
32 Views
Last Modified: 2016-07-26
Hi, was hoping someone could give me some troubleshooting ideas on an issue I am having for a user with an excel start Macro.

For the user, when she logos on and opens  Excel, it doesn't load/show up as an ADD-IN or as available.
When I or anyone else logs on, it loads and works fine.

I have tried a office repair, but don't think its the install, seems to have something to do with her profile, but it doesn't make sense to have to give her a whole new profile for such a small thing. Just need to have some idea of what could be the prblem
Scan0001.pdf
0
Comment
Question by:GST-GRIDTECH
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 41715008
For clarity:
Are you referring to a Workbook_Open() or Auto_Open() event in a workbook that is opened manually by the user, or to a workbook that resides at the Startup location shown in your attached ".pdf" (L:\offadmin\altstart) & that you are expecting to be opened automatically when an MS-Excel application session is launched?

If the former, what code statements are within either (or both) of those two events?
If the latter, does the user have sufficient network privileges to open files in that location?

Additionally, what is shown within your user's "Macro Settings" of the "Trust Center"?

MS-Excel 2013 Trust Center Macro Settings
0
 

Author Comment

by:GST-GRIDTECH
ID: 41715681
Hi, Thank you for responding.

Startup location shown  (L:\offadmin\altstart)

user does have the privileges.

It seems to be something on the local machine specific to her profile.
If she goes to another PC, it works .

if I or anyone else logs onto her PC it works, like it works for EVERYONE in the company All 300.
but not fer her on her assigned PC.


I did compare her  "Macro Settings" of the "Trust Center" and they MATCH what everyone else has,
but I don't recall what it is right now..but i did compare her setting to everyone's and they match..
0
 
LVL 35

Assisted Solution

by:[ fanpages ]
[ fanpages ] earned 500 total points
ID: 41715686
...so is it a Workbook_Open()/Auto_Open() event, or a file within the Startup file location?

I will presume the latter.

What if this colleague uses another machine (with the same log-in credentials)?

Does that replicate the issue on that machine (for that single user, or for all users), or does it work on other PCs (just not on the individual's assigned PC)?

That is; is the issue restricted to the PC, the user, or the user/PC combination?
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 

Author Comment

by:GST-GRIDTECH
ID: 41716040
Hi,

its a file within the Startup file location.
if the user logs on to another PC. No issue.

If I or Anyone logs onto her PC, not issue.
it is ONLY when she logs ONTO that PC and I would hate
to have to give her a new profile, just because of this
Excel issue.    there has to be some way to correct the issue..
0
 

Author Comment

by:GST-GRIDTECH
ID: 41716074
its a file within the Startup file location., everyone has this file for excel., in the same startup location and the location is in everyones trusted file location.
0
 
LVL 35

Assisted Solution

by:[ fanpages ]
[ fanpages ] earned 500 total points
ID: 41716103
Can you set the Startup location for the problematic user/PC combination to a different network location or, perhaps, a local hard drive, temporarily, then copy the file from the "L:\offadmin\altstart" folder to the new location?

This my establish if there is a problem with the original Startup location, or with the workbook file.
0
 

Accepted Solution

by:
GST-GRIDTECH earned 0 total points
ID: 41723885
turns out, this was a systems admin error, that could only be corrected, by the Admin at the site.
i dint have the privileges to correct,,,
0
 

Author Closing Comment

by:GST-GRIDTECH
ID: 41729212
turns out, this was a systems admin error, that could only be corrected, by the Admin at the site.
i dint have the privileges to correct,,,
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question