+ Reply to Thread
Results 1 to 3 of 3

Excell 2010 comments not showing and drop down lists not showing correctly in Excell 2013

  1. #1
    Registered User
    Join Date
    11-06-2016
    Location
    Manchester
    MS-Off Ver
    2010
    Posts
    9

    Excell 2010 comments not showing and drop down lists not showing correctly in Excell 2013

    I have created a spreadsheet which includes fairly large number of pop-up comments to help user and several drop down lists. I use Excell 2010. When the spreadsheet is open with Excell 2013 and later, drop down lists don't work as they should- they need to be clicked on twice or more to show the lists. Many comments contain embedded pictures and they don't show when mouse pointer is hovering over the cells containing them.
    Drop down list issue was temporarily resolved by using code for automatic change of column width but once the sheet is protected this doesn't work.

    Can anyone please assist?
    Sample file is included.
    Attached Files Attached Files

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excell 2010 comments not showing and drop down lists not showing correctly in Excell 2

    Your file produces an error when downloaded and opening is attempted.
    Attached Images Attached Images
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    11-06-2016
    Location
    Manchester
    MS-Off Ver
    2010
    Posts
    9

    Re: Excell 2010 comments not showing and drop down lists not showing correctly in Excell 2

    For some reason all comments within the spreadsheet have disappeared when i downloaded and opened it.

+ 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] DATEDIF function is not working in Excell 2013
    By SoftwareUzer in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-12-2020, 01:28 PM
  2. Data not showing up correctly on a graph in Excel 2013
    By The_Signal in forum Excel General
    Replies: 2
    Last Post: 07-14-2014, 02:06 PM
  3. download excell file using excell 2010 not excell 97-2003
    By devexcell in forum Excel General
    Replies: 2
    Last Post: 06-02-2014, 07:03 AM
  4. items in drop down lists in excel combo box not showing
    By Jonno1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-03-2014, 03:45 PM
  5. Excell magic to open an excell sheet at a predetermined time
    By catchnanan in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-11-2013, 08:21 PM
  6. Excel 2007 : excell cell comments
    By mubeenff in forum Excel General
    Replies: 2
    Last Post: 05-29-2011, 03:54 AM
  7. [SOLVED] How to you lockout the comments in Excell from other users?
    By rescue336 in forum Excel General
    Replies: 2
    Last Post: 05-13-2005, 01:06 PM

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