R
Rick
Hello
I have a SQL 2000 local cube that I created on my computer that is accessed
by an
Excel (XP) pivot table workbook. I would like to place & run both on a
secure sub-web on my company http:// website. Both files were FTP'ed to the
sub-web successfully. When opening the Excel file I am prompted for the
local cube: the prompt is referencing the cube location on my computer where
it was originally created with SQL 2000. I am unable to point it to the
sub-web location. It appears that the Excel workbook has hard coded the
original cube location back to my computer.
Is there a way around this problem? I would like to access the Excel
workbook & the local cube from the sub-web.
Thanks in advance.
Rick
I have a SQL 2000 local cube that I created on my computer that is accessed
by an
Excel (XP) pivot table workbook. I would like to place & run both on a
secure sub-web on my company http:// website. Both files were FTP'ed to the
sub-web successfully. When opening the Excel file I am prompted for the
local cube: the prompt is referencing the cube location on my computer where
it was originally created with SQL 2000. I am unable to point it to the
sub-web location. It appears that the Excel workbook has hard coded the
original cube location back to my computer.
Is there a way around this problem? I would like to access the Excel
workbook & the local cube from the sub-web.
Thanks in advance.
Rick