+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Excel 2203 to 2007 fill handle formatting issue

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    1

    Excel 2203 to 2007 fill handle formatting issue

    Hello all,

    I'm having a problem when I use the fill-handle to populate a list within a table. Everything works fine in Excel 2007, but the issue comes about when the file (.xlsm) is opened in Excel 2003 because the formatting gets messed up. In 2007, all that's shown is a small backwards L to signify where I ended using the fill-handle, but then in 2003, the whole area that was dragged has a box around it and sometimes the colors are turned white.

    Is there a way that I can hide the fill--handle from showing up when another person opens up the file and a way that the formatting won't get ruined when opened in 2003?

    Thanks!!

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Excel 2203 to 2007 fill handle formatting issue

    Hi junks,
    welcome to the forum.

    One way to hide the fill handle is to lock the cells and protect the worksheet, but I'm not sure that this will suit your workflow.
    When you use 2007 make sure you work in compatibility mode when designing a spreadsheet that needs to be shared with 2003 users. On top of that, make sure to stick to formats that you know work for 2003.

    I'd be interested to see an example of your file, so please attach some sample data that shows the behaviour you describe.

    cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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