Hi
I am new to power pivots but find them really useful
However I have hit a bit of a problem
I added an excel spreadsheet to the data model and created my pivots. However I decided I wanted to amend the excel sheet name rather than it being Sheet1. I thought if I edited the existing connections I would be able to do this but there is only an option to browse a new filename not the sheet name. I appreciate I could just add my data again but i have added too many calculated fields so don't want to start again,
Any ideas please if this is possible
Jacc14
Bookmarks