Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel data on intranet pages
Resolved · Medium Priority · Version 2003
Alex has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
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
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. |
We'll call during UK business hours
Server loaded in 0.08 secs.