Microsoft Office appears not to function correctly

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Microsoft Office appears not to function correctly

Post by ABabeNChrist »

A friend is using an excel workbook of mine. It was working great for the last couple years. Then a couple months ago they started having problems with error messages that seem to occur when using a command button to run some code (to insert photo or to navigate). At the time they were using Microsoft office 2007. Thinking that 2007 might be the problem, so they then installed Microsoft office 2016. The problem seems to still be there and it seems to be random as it doesn’t always occur and may function ok on some sheets and not others. I then tested there workbook on my computer and it worked great.

I was wondering if some type of update may have caused this or possibly two versions of office installed causing conflict.

Here is a screen shot of the programs
Screen shot2.jpg
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Microsoft Office appears not to function correctly

Post by HansV »

Did you use non-standard controls in the workbook (either on a worksheet or on a userform)?
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Microsoft Office appears not to function correctly

Post by ABabeNChrist »

Yes, also I was wondering if a 32 or 64 bit installation could cause this?

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Microsoft Office appears not to function correctly

Post by HansV »

Do you have 32-bit or 64-bit Office yourself?
Does the other user have 32-bit or 64-bit Office?
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Microsoft Office appears not to function correctly

Post by ABabeNChrist »

My computer is 64 bit and I and using Office 2007

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Microsoft Office appears not to function correctly

Post by ABabeNChrist »

The screen shot above is from there computer, it looks to be 64 also

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Microsoft Office appears not to function correctly

Post by ABabeNChrist »

I believe 2007 is 32 bit, so if my friend reinstalls 2016 they should probably select 32 bit, does that sound right

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Microsoft Office appears not to function correctly

Post by HansV »

Virtually everyone has 64-bit Windows nowadays, but that is not relevant. The important question is whether Office is 32-bit or 64-bit. Most users have 32-bit, but if your user has 64-bit Office, that might explain the problem.
If they currently have 64-bit Office, it would be a good idea to remove it and to install the 32-bit version, if they have the option to do that.
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Microsoft Office appears not to function correctly

Post by ABabeNChrist »

Perfect thank you Hans