+ Reply to Thread
Results 1 to 23 of 23

ColorCount does not work on shared file

  1. 10-13-2019, 11:58 AM #1
    cayuga306
    cayuga306 is offline
    Registered User
    Join Date
    01-01-2019
    Location
    Depew, NY
    MS-Off Ver
    2019 and 2016
    Posts
    22

    ColorCount does not work on shared file

    I am using the CountCcolor function in a shared spreadsheet (on a network). It works just fine when I have it open, however when anyone else has it open the get a name error. Excel (2016) wants to update a link, but will not. What do I need to do so that this works on the other desktops as well.

    The function still works in an older spreadsheet, but in this new one (which is just copied and renamed) it would not work. Suggestions?

    This what the other desktops see when trying to update the link: 'C:\Users\sundberc\AppData\Roaming\Microsoft\AddIns\2019 Qtr 3 Yellow OT.xlam'!CountCcolor(F7:AJ7,$I$3)+B7
    they should see =CountCcolor(F7:AJ7,$i$3)+B7
    Reply With QuoteRegister To Reply
  2. 10-13-2019, 12:09 PM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: ColorCount does not work on shared file

    The misspelling, perhaps?

    CountCcolor

    The other workbooks will need the UDF, too, and be macro-enabled - is this the case? Are you trying to run this in a browser environment? This is not a native Excel function.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-13-2019, 12:12 PM #3
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: ColorCount does not work on shared file

    The function CountCcolor is not a built-in function. It's an add-in that user "sundberc" has installed on his machine (are you "sundberc"?). But nobody else has it, so it doesn't work for them. The fix for this is to put the code directly into a standard module in the shared workbook.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  4. 10-13-2019, 12:20 PM #4
    cayuga306
    cayuga306 is offline
    Registered User
    Join Date
    01-01-2019
    Location
    Depew, NY
    MS-Off Ver
    2019 and 2016
    Posts
    22

    Re: ColorCount does not work on shared file

    Yes I am "sundberc". I have removed tried removing the module and recreating it, I have also attempted to use the CountColor function with the same results, everytime. I can't seem to get the module to imbed in the spreadsheet. I have tried Alt+F11 and insert module and then cut and pasted the code. Am I missing a step?
    Reply With QuoteRegister To Reply
  5. 10-13-2019, 12:31 PM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: ColorCount does not work on shared file

    You haven't answered my questions - may be relevant.
    Reply With QuoteRegister To Reply
  6. 10-13-2019, 12:39 PM #6
    cayuga306
    cayuga306 is offline
    Registered User
    Join Date
    01-01-2019
    Location
    Depew, NY
    MS-Off Ver
    2019 and 2016
    Posts
    22

    Re: ColorCount does not work on shared file

    Sorry, no it is spelled correctly. It is the same here: https://docs.microsoft.com/en-us/off...olor-using-vba
    Reply With QuoteRegister To Reply
  7. 10-13-2019, 12:48 PM #7
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: ColorCount does not work on shared file

    You haven't answered my final question.
    Reply With QuoteRegister To Reply
  8. 10-13-2019, 12:53 PM #8
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: ColorCount does not work on shared file

    Quote Originally Posted by cayuga306 View Post
    I have tried Alt+F11 and insert module and then cut and pasted the code. Am I missing a step?
    You will need to take the workbook out of shared mode, add the code, save & then make it shared again.
    Reply With QuoteRegister To Reply
  9. 10-13-2019, 12:56 PM #9
    cayuga306
    cayuga306 is offline
    Registered User
    Join Date
    01-01-2019
    Location
    Depew, NY
    MS-Off Ver
    2019 and 2016
    Posts
    22

    Re: ColorCount does not work on shared file

    No, it is not in a browser environment. It is on a network drive and available to one person at a time.
    Reply With QuoteRegister To Reply
  10. 10-13-2019, 12:58 PM #10
    cayuga306
    cayuga306 is offline
    Registered User
    Join Date
    01-01-2019
    Location
    Depew, NY
    MS-Off Ver
    2019 and 2016
    Posts
    22

    Re: ColorCount does not work on shared file

    It is not in shared mode. It is, however, stored on a network drive.
    Reply With QuoteRegister To Reply
  11. 10-13-2019, 01:01 PM #11
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: ColorCount does not work on shared file

    Have you saved the workbook as macro enabled with an .xlsm extension?
    Reply With QuoteRegister To Reply
  12. 10-13-2019, 01:04 PM #12
    cayuga306
    cayuga306 is offline
    Registered User
    Join Date
    01-01-2019
    Location
    Depew, NY
    MS-Off Ver
    2019 and 2016
    Posts
    22

    Re: ColorCount does not work on shared file

    Yes, it is saved as .xslm.
    Reply With QuoteRegister To Reply
  13. 10-13-2019, 01:14 PM #13
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: ColorCount does not work on shared file

    Attach the workbook here, please.
    Reply With QuoteRegister To Reply
  14. 10-13-2019, 01:15 PM #14
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: ColorCount does not work on shared file

    In that case I can think of no reason why the code would not stay in the shared workbook.
    Reply With QuoteRegister To Reply
  15. 10-13-2019, 01:28 PM #15
    cayuga306
    cayuga306 is offline
    Registered User
    Join Date
    01-01-2019
    Location
    Depew, NY
    MS-Off Ver
    2019 and 2016
    Posts
    22

    Re: ColorCount does not work on shared file

    Quote Originally Posted by AliGW View Post
    Attach the workbook here, please.
    It is attached.
    Reply With QuoteRegister To Reply
  16. 10-13-2019, 01:47 PM #16
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: ColorCount does not work on shared file

    Nope, it's not.

    To upload a workbook, Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Reply With QuoteRegister To Reply
  17. 10-13-2019, 02:11 PM #17
    cayuga306
    cayuga306 is offline
    Registered User
    Join Date
    01-01-2019
    Location
    Depew, NY
    MS-Off Ver
    2019 and 2016
    Posts
    22

    Re: ColorCount does not work on shared file

    Don't know what happened. It took four tries. But it shows there now.
    Last edited by AliGW; 10-13-2019 at 04:21 PM.
    Reply With QuoteRegister To Reply
  18. 10-13-2019, 02:15 PM #18
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: ColorCount does not work on shared file

    I can't see an attachment in any of your posts.
    Reply With QuoteRegister To Reply
  19. 10-13-2019, 04:22 PM #19
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: ColorCount does not work on shared file

    No, there is no attachment in this thread, I’m afraid. You will need to try again.
    Reply With QuoteRegister To Reply
  20. 10-13-2019, 04:36 PM #20
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: ColorCount does not work on shared file

    Quote Originally Posted by cayuga306 View Post
    Don't know what happened. It took four tries. But it shows there now.
    If your file is over 1MB, it won't be allowed. It might look like it was attached but the error message is not very prominent. If it is larger than 1MB then you can zip it. A zip file is allowed to be up to 9.77MB.
    Reply With QuoteRegister To Reply
  21. 10-13-2019, 04:49 PM #21
    cayuga306
    cayuga306 is offline
    Registered User
    Join Date
    01-01-2019
    Location
    Depew, NY
    MS-Off Ver
    2019 and 2016
    Posts
    22

    Re: ColorCount does not work on shared file

    I wasn't hitting submit after putting on the attachment.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  22. 10-13-2019, 06:40 PM #22
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: ColorCount does not work on shared file

    I updated your formulas to use CountCcolor in the workbook instead of the external reference. That should fix it for everyone.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  23. 10-13-2019, 06:47 PM #23
    cayuga306
    cayuga306 is offline
    Registered User
    Join Date
    01-01-2019
    Location
    Depew, NY
    MS-Off Ver
    2019 and 2016
    Posts
    22

    Re: ColorCount does not work on shared file

    Quote Originally Posted by 6StringJazzer View Post
    I updated your formulas to use CountCcolor in the workbook instead of the external reference. That should fix it for everyone.
    Ok, I'm looking at it, can I ask what you updated exactly? The formula looks the same. I'm sure I'm missing something.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro enabled file - work on shared
    By rajeev.raj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2019, 08:10 AM
  2. macro doesn't work in shared file
    By petezky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2017, 11:03 AM
  3. Edit Shared Work File
    By suhabthan in forum Excel General
    Replies: 1
    Last Post: 08-13-2014, 10:12 AM
  4. Excel Colorcount
    By rrv in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2013, 05:18 AM
  5. Shared Excel 2010 File with macros that do not work
    By Dave Herbert in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2012, 10:35 AM
  6. shared work book
    By darknight in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-04-2007, 04:18 PM
  7. Work book shared
    By kiran in forum Excel General
    Replies: 8
    Last Post: 06-22-2005, 01:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1