Import data from Password Protected Spreadsheet (1 Viewer)

I have a spreadsheet located on our network called dps2006.xls. This sheet is password protected. I want to know how i can import data from a tab called cream summary. i havent had any luck doing it. i can get non password protected to work fine.