references to cells in pivot table

[jmhultin]

I just reinstalled Excel 2007 after a HD reformat, and now I'm trying to recreate all my little personal preferences.

1 - when I create a formula by pointing to a cell in a pivot table, I get some atrocious formula that's useless to me. How can I switch this off to get a normal cell reference.

2 - also - when I "Open File", I want to always see "details" as the default view. I can do this for My Computer from the control panel but that doesn't affect the view format in the Open file within Excel. When I click Organize in the Open dialogue box, Folder and Search Options is not available.

Thanks