View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TKS_Mark TKS_Mark is offline
external usenet poster
 
Posts: 68
Default Office 2007 Trace Precedents + Tables

I use formula references between sheets to table values. For instance,
"=BoothCoated[[#Totals],[sf]]". But when I click the "trace precedents"
button, a popup says that valid references are required.

How can I make that trace precedents command work properly with table
references so that auditing spreadsheets is more automated?