Skip to Content
0
Former Member
Mar 19, 2010 at 06:16 PM

SP3 FP1 -- INDIRECT function unsupported?

16 Views

According to online help and full user guide doc, INDIRECT is on the list of Excel functions that are supported in this release. However, whether using text, R1C1 reference or concatenating pieces together by formula, I still get "Unsupported Function INDIRECT" error when generating swf file from preview. It does not show error on export to swf but does not render data either. I have tried with INDIRECT referencing same sheet and across sheets with same results.

Thanks for any tips. I need INDIRECT to create sheetname to cell reference so Index/Match/Lookups don't help.