I'm preparing simple template with costcentre in rows and Time in columns. Each column has different format and formulas
Ex:2006.APR 2006.MAY 2006.JUN 2006.JUL 2006.AUG 2006.SEP 2006.OCT
CC1 formula1 formula2 plain yellowcolor Blue color Grey color
CC2 '' '' '' '' ''
But EPMFormat sheet not appearing format upto 2006.JUN only (i.e upto 3 columns), after that from 4th column (2006.JUL, 2006.AUG, 2006.SEP)onwards not recognizing.
I tried with second option local members also like L1, L2, L3, L4 in columns, upto 3rd column formwat will appear fine, later from 4th column onwards format is not recognizing.
Is there any limit for EPMformat sheet, i don't think so, many reports prepared with different format in the columns, Did i'm missing anything