+ Reply to Thread
Results 1 to 8 of 8

Macro Workbook not displaying logo on some computers

  1. #1
    Registered User
    Join Date
    06-16-2021
    Location
    Perth, Australia
    MS-Off Ver
    Home and Business 2019
    Posts
    4

    Macro Workbook not displaying logo on some computers

    Just wondering if anyone has come across a similar issue...we have an excel macro worksheet we use in our business and have done for years. Sometimes if we edit it (macros never change) when we save and go back into it to use, it doesn't show our company logo on some computers and we get a debug error but had worked in the past?? If we open previous versions of it on the same computer it's not working on, it does the same. All of our computers are operating windows 10.

    If i open excel in 'safe' mode it works ok.
    So far I have done the following -
    -checked for updates and installed for excel
    -turned off all add ins in excel
    - excel trust centre - enabled all macros

    I am just wondering if its possibly an update that is affecting this but after searching the net it's hard to find anyone with a similar problem.
    I know it will be an easy enough fix but from everything we have tried so far, nothing seems to be working..

    Using Excel 2019.

    Any suggestions would be greatly appreciated!! Thanks in advance.
    Last edited by sforcebsn; 06-17-2021 at 11:33 PM.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Macro Workbook not displaying logo on some computers

    Are you including a copy of the company logo with each version of the workbook. Having that logo
    installed on the computer and a path reference included in the workbook ?

    Or how have you included the logo ?

  3. #3
    Registered User
    Join Date
    06-16-2021
    Location
    Perth, Australia
    MS-Off Ver
    Home and Business 2019
    Posts
    4

    Re: Macro Workbook not displaying logo on some computers

    The logo has been there from when the sheet was created (about 15 years ago)
    It was inserted into the sheet from google drive (which all computers have access to) It was added onto the sheet using insert picture, from this device. I have even tried inserting from the actual computer it's not working on so it's local but that still didn't work.
    basically its on a hidden sheet which you can see the logo on that but then when we hide the sheet and using the macro "create new sheet" on that sheet it doesn't display the logo. Sorry not up with excel lingo as I never created the worksheet but we have used it for years and the only time we come across issues is if we update something on the sheet. The macros never get changed as we they all work fine. We had this happen few years back and I think it was a KB update that we uninstalled which fixed it but I can't find any relating to that. thanks for your help

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Macro Workbook not displaying logo on some computers

    .
    If I correctly understand, the image actually resides on Google Drive. Isn't that on the internet and not on the individual computers ?

    If so, it sounds like some of the computers may be having difficulty accessing the internet and the logo image there.

  5. #5
    Registered User
    Join Date
    06-16-2021
    Location
    Perth, Australia
    MS-Off Ver
    Home and Business 2019
    Posts
    4

    Re: Macro Workbook not displaying logo on some computers

    i've tried both ways, accessing from google drive and individual hard drive. Just had our IT guy look at it and he tried reinstalling office but still hasn't fixed problem. He thought once before we had to reinstall windows 10 but surely we don't have to keep doing that each time we edit the spreadsheet. I've only changed text in the sheet itself, no changes to the macros.

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Macro Workbook not displaying logo on some computers

    If you have maintained a copy of the ORIGINAL correctly functioning workbook .... is it that copy you have used to load onto all machines ?
    Or how have you attempted to re-load the workbook (what copy or version of the workbook) ?

    What I'm thinking is possibly a corrupted version has been re-loaded ?

    I agree that you don't need to reload Windows every time there is an issue.

    I'm wondering if there is something different about the troubled machines from the non-issue machines. Perhaps an app the user has loaded
    that is not present on the others. Perhaps this extraneous software is creating an issue ? If not ... It seems to me there is something errant in the
    non-working machines vs something wrong with the workbook.

    There are so many variables in an issue like this ... very difficult to pin down. Wish I had a magic wand that would fix it all.

  7. #7
    Registered User
    Join Date
    06-16-2021
    Location
    Perth, Australia
    MS-Off Ver
    Home and Business 2019
    Posts
    4

    Re: Macro Workbook not displaying logo on some computers

    thanks, turns out it was a corrupt windows user profile causing the problem...

  8. #8
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Macro Workbook not displaying logo on some computers

    So glad you found the issue.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel Macro Runs on Some Computers, Not All- Stalls for computers where it fails to run
    By jamie.harris in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-25-2018, 04:54 PM
  2. [SOLVED] Logo Throughout Workbook
    By Billy Spivy in forum Excel General
    Replies: 5
    Last Post: 01-16-2018, 12:06 PM
  3. inserting a logo via macro
    By queenbee1982 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2016, 11:02 PM
  4. Replacing Logo images across workbook from a specified file location
    By liquidmettle in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-20-2015, 08:53 AM
  5. Replies: 1
    Last Post: 07-18-2013, 09:31 AM
  6. Macro to take data from one workbook to another on different computers
    By Libster78 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2010, 08:47 AM
  7. [SOLVED] Moving workbook with VBA between computers
    By Revolvr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2005, 10:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1