in reply to Internal links in Excel

I use Spreadsheet::WriteExcelXML to do this. check out the write_url section.