+ Reply to Thread
Results 1 to 2 of 2

Error Checking flags not showing up in cells

  1. #1
    Registered User
    Join Date
    05-28-2013
    Location
    PEI, Canada
    MS-Off Ver
    Excel 2010
    Posts
    4

    Error Checking flags not showing up in cells

    Hi All,

    I have a user here who has lost his error checking flags (little green triangles). I open his spreadsheets on my laptop and the cells with 2 digit years show green flags. On his computer, nothing but alignment issues; two digit years to the left and four digit years to the right. I have checked his settings in Options-Formulas and all error checking is turned on. I have tried the Microsoft Fixit and Registry edits to reset Excel to default settings. Nothing is bringing his green triangles back.
    I'm at a loss. Can anyone give me solution?

    Libby

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Error Checking flags not showing up in cells

    Hi Libby
    The first thing you need to do is make sure you are BOTH using the same version of the Excel Template as this may display things differently on both machines. The other option you can use initially is for the Master Excel workbook to be saved as a template. Then you can receive that workbook without any formatting issues.
    Hope this helps.
    Good luck.
    Tony

+ 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. HELP! need a lesson on referencing and error checking two cells
    By wiskydiver25 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-13-2012, 01:28 AM
  2. Macro for Error Flags
    By galatians220 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2012, 07:27 AM
  3. Replies: 7
    Last Post: 02-05-2012, 06:50 PM
  4. Replies: 10
    Last Post: 10-24-2011, 02:15 AM
  5. checking cells are empty and giving error message
    By Nick_in_Dubai in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2009, 05:17 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