#1
|
|||
|
|||
Dynamic Dashboard on company intranet
What I need to do is create a simple dashboard (Spreadsheet_Destination) that graphs the most recent 20 values of a list in Spreadsheet_Source which is located elsewhere on the company shared network. I thought this would be easy. I made a list in Spreadsheet_Source and a graph of it, then copy and pasted that graph on to Spreadsheet_Destination. Every time I typed in Spreadsheet_Source I saw the immediate update on the Spreadsheet_Destination graph which of course was showing at the time. Thought all was good until I tried opening the Spreadsheet_Destination in another folder on the company network just to prove that the links worked and adding a value in Spreadsheet_Source would immediately be reflected on Spreadsheet_Destination. Since the source spreadsheet never moved the links were intact. The experts here know what I am going to ask. How to have the destination spreadsheet acting as a dashboard update in conjunction with the source spreadsheet.
Any help would be greatly appreciated as I have spent way too long digging around the internet for just the perfect solution to this particular problem. Please be explicit. Thanks. |
Tags |
dashboard, dyanmic, shared network |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dashboard | neilw | Excel | 0 | 07-06-2014 12:22 PM |
any idea how to add a master dashboard or control panel that is able to tell my formu | akatz85 | Excel | 6 | 03-27-2014 01:13 PM |
Powerpoint Dashboard | Villanueva | PowerPoint | 0 | 08-26-2013 10:16 PM |
Change font across company | Dill | Excel | 1 | 11-04-2009 08:21 PM |
Outlook calander on intranet | k6868 | Outlook | 0 | 08-05-2009 08:54 AM |