Big dream of an idea - Would it be possible to integrate Excel, Word & PowerPoint, and/or Access/SQL??
At work I am doing database querying, popping this data into Excel for more flexible analysis, including preparing graphs and other calculations, creating nice formatted exhibits. I also then write up my analysis in Word, copy/paste the graphs and small number table exhibits created in Excel. And/or I create a PowerPoint presentation from the work done in Excel or the write-up done in Word.
All this copying & pasting is tedious, you lose formatting, and if anything changes, you have to do it all over again. I have found that linking all the content together just doesn't work. Plus, you have at least 3 different files - .xlsx, .docx, .pptx that you need to keep track of, including versions.
It would be EXTREMELY NICE to have them all integrated into one application!! For instance, designate some tabs to be Excel worksheets, designate some tabs to be Word document(s), some tabs to be PowerPivot data sheets, some tabs to be PowerPoint slides. And have the data work together, for instance, the graph you just created in Excel can appear in the Word & PowerPoint tabs and is 'live' so that you don't have to re-do a lot of cutting & pasting if data changes.
I would vote 100 votes on this but I think I'm down to my last vote...
Kevin Bouwman commented
Darren, you clearly do not experience the use cases some of us do. Before computers it would be very logical to have one document contain tables, charts, drawings, and text. When computers were new their capabilities were limited so Microsoft created a word processor, later a spreadsheet, and still later a presentation program and a database program. As time passed they made several stabs at giving us the ability to create the cohesive document we wanted by developing OLE and later Binders. Neither of these was implemented elegantly enough to really work. Part of this was the limitations of computers and some of it was just a wrong headed approach. The Excel workbook though is a great paradigm for this as Scott Sobel describes. Creating a new document definition that is a superset of an Excel Workbook, an Office Workbook if you will, would just make sense. Whether that Office Workbook would be edited in separate, enhanced, versions of the current office applications or in a new single super application wouldn't matter to me. I just really could use a more elegant way to link information from databases and tables into other databases, tables, graphs, and rich text documents. A PHD thesis where the analysis and report draw directly from data tables and spreadsheets all within one document. Easy to manage, easy to backup, no links full of fragile file system links.
I can only laugh at the stupidity of some people. Use the right tool for the job for starters...
There is also a similar idea here...
(I've just posted a comment there to suggest that the ideas be merged)
I posted a similar idea here...
It's only received 2 votes since July (including my own) - so I'm not hopeful.
Perhaps a moderator could merge the ideas, and we'll get it up to 4 votes!