Results 1 to 5 of 5

Table Banding and Formulas Not Working

Threaded View

Bportz Table Banding and Formulas... 04-03-2017, 08:12 PM
Bportz Re: Table Banding and... 04-03-2017, 08:29 PM
Bportz Re: Table Banding and... 05-01-2017, 04:22 PM
Bportz Re: Table Banding and... 05-01-2017, 04:23 PM
Bportz Re: Table Banding and... 05-01-2017, 04:16 PM
  1. #1
    Registered User
    Join Date
    08-18-2012
    Location
    Canada North
    MS-Off Ver
    Excel 2010 / 2016
    Posts
    9

    Table Banding and Formulas Not Working

    When I try to convert a range to a table only some columns are banded, the first column and a few on the far right of the range.

    Not sure if its related, but formulas do not pick up table references - I just get cell references. This is even though the table shows as created for the range in question and filters were created indicating the full range was in fact converted to a table.

    Any idea what is wrong here?
    Last edited by Bportz; 04-03-2017 at 08:18 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] if else banding
    By nicci113 in forum Excel General
    Replies: 5
    Last Post: 08-28-2014, 11:06 AM
  2. Generation Banding
    By forrestgump1980 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2013, 08:57 AM
  3. Banding Rows, but only ones that need it
    By Aegwyn11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2012, 01:31 PM
  4. Number Banding
    By Djsban in forum Excel General
    Replies: 3
    Last Post: 04-30-2010, 06:02 AM
  5. Excel 2007 : Excel Banding
    By Strathcona in forum Excel General
    Replies: 10
    Last Post: 08-13-2009, 01:58 PM
  6. Row Banding
    By berz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-24-2008, 03:22 AM
  7. rubber banding
    By rubber banding in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-14-2005, 09:07 AM

Tags for this Thread

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