Skip to Content
0
Former Member
Jan 05, 2011 at 10:08 PM

Excel range is altered while objects are refreshed in LO

31 Views

There are 4 sheets in the enclosed Excel.

https://docs.google.com/leaf?id=0Bxr21rPZha4-ZTczZmRiZjAtOTMxOS00M2VmLTg0MzUtZmJkMTE5Y2YyNWNj&hl=en&authkey=CJrVkMAF

Sheet 1 - The output from the WEBI report, connected using the LO Connection. Column H - The calculation on the LO output. Field L4 - is the prompt.

Sheet 2 - Modified Prompt to 201012

Sheet 3- Modified Prompt to 201101

Sheet 4 - Modified Prompt to 201010

On changing the Prompt value, the Column H returns the "#REF!" error. Please help in resolving this problem.

Thanks in advance.

Edited by: Ashish Goel on Jan 6, 2011 3:38 AM