Excel data on intranet pages

Resolved · Medium Priority · Version 2003

Tue 29 Jul 2008, 16:27 Delegate Alex said...

Alex has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course

Excel data on intranet pages

I currently save performance related statistics on a dedicated intranet page as separate spreadsheets that people may access by clicking on the icons. I would like to know if there is a better way to display this data on the pages, so that can be easily updated, accessed and manipulated by numerous users

Wed 30 Jul 2008, 14:09 Trainer Simon said...

RE: Excel data on intranet pages

Hi Alex,

Thank you for the question.

If it is possible with your data to create pivot tables, then you can publish the pivot table onto the web allowing Interactivity using the Pivot table functionality.

I will also assign this question to another colleague and see if he has any ideas.

Regards

Simon

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips

Excel data on intranet pages

Excel data on intranet pages

RE: Excel data on intranet pages

Excel articles

Excel tip:

Autofit column width – Excel (all versions)