D
Dave
Greetings.
I have a single Spreadsheet which contains data I want to publish on the
Web. I am currently using the Auto-publish feature, and everything was going
fine...
However, I now need to publish a second view of this data (i.e. different
colomns than in the first published file). Since it is not possible to
publish two differet sets of data Ifrom the same file, I tried to create a
second html spreadsheet and reference the required cells in the original
sheet. However, these references only update if both sheets are currently
open, and of course I want them to update automatically. Can anyone help? Or
does anyone know of another way I can publish diffeent views of the same
data? I'm using Excel XP 2003 and also have Windows Sharepoint if that helps.
Thanks,
Dave.
I have a single Spreadsheet which contains data I want to publish on the
Web. I am currently using the Auto-publish feature, and everything was going
fine...
However, I now need to publish a second view of this data (i.e. different
colomns than in the first published file). Since it is not possible to
publish two differet sets of data Ifrom the same file, I tried to create a
second html spreadsheet and reference the required cells in the original
sheet. However, these references only update if both sheets are currently
open, and of course I want them to update automatically. Can anyone help? Or
does anyone know of another way I can publish diffeent views of the same
data? I'm using Excel XP 2003 and also have Windows Sharepoint if that helps.
Thanks,
Dave.