Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel data on intranet pages

Excel data on intranet pages

ResolvedVersion 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:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Excel data on intranet pages

Excel data on intranet pages

RE: Excel data on intranet pages

Excel articles

Excel tip:

View a unique list