Debugging managed UDF running under Sharepoint Excel services

I am trying to debug a UDF running under sharepoint. I have attached to the right w3wp process under which the shared services is running.

When I attach to the process, it doesnt load the symbols for my UDF assembly. I have my PDB's in the same location as the UDF.

'w3wp.exe' (Managed): Loaded 'C:\Sharepoint UDF\ExcelSampleUDF.dll', No symbols loaded.

Why are not the symbols loaded?

[396 byte] By [PradeepTKumar] at [2008-2-8]

«« Carriage return in header of Flat File Destination
»» WSDL version support?

# 1

This blog post should help you out:

http://blogs.msdn.com/cumgranosalis/archive/2006/07/12/DebugUDFs.aspx

Most likely you are attaching to the wrong w3wp process.

LuisBitencourt-Emilio-MSFT at 2007-9-6 >

top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Excel Services...

# 2

I actually followed that already.. attaching to the correct w3wp process. the problem seems to be that a dll was not copied correctly.(Sorry about that)

Now the other issue is I can get into debugging - step through, only when I republish for the first time. subsequently if I refresh or reload the workbook, it doesnt hit the breakpoints.
So I think there is a caching results happening here.. how do I tweak those to always run my code and not cache the results?

PradeepTKumar at 2007-9-6 >

# 3

You can mark your UDF as volatile, so that it will be called each time you explicitly calculate the workbook.

http://blogs.msdn.com/cumgranosalis/archive/2006/09/12/VolatileUdfs.aspx

IraLevin at 2007-9-6 >

# 4

Did the above posts answer your question? If so could you please mark it as the answer?

Otherwise let us know what you still need help with.

Thanks!

- Luis

LuisBitencourt-Emilio-MSFT at 2007-9-6 >

SharePoint Products and Technologies