 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Links / July 2005Spreadsheet within a spreadsheet...
Hi... simple problem. I have made a spreadsheet that employees will fill out. There is one per customer job. I have attempted to make one workbook that will link to all the others so i can monitor the status' of the job spreadsheet. So... easy right? I use the 'insert/object/new from file/link to file'. Choose the other sheet and hit OK. The linked sheet imports BUT, it seems to treat it as a graphic and cuts the table in half (roughly). I tried to resize using the grips - but that just stretchs or shrinks the half chart image. Now... anyone know how to get the whole chart to show? This is in office 2000 on Win2000pro. Cheers and thanks!! J Inserting one workbook into another as a linked object is an unusual thing to do. If you double-click it, it will open up the source workbook, I assume. If you want to see certain cells in the source workbook it would be more usual to create a formula link to the specific cells. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup I agree with you Bill, it is a odd thing, but it works perfectly for what i am trying to do. It almost seems as if excel is bringing in the other sheet as a graphic - but i can not control the size(resolution i guess) of the inserted sheet. Maybe there is another way to monitor several worksheets from one point? I am not stuck on using excel for this but it seems the easiest method - if anyone can suggest any other way to monitor mulitple sheets in mulitple folders... :) Cheers! J. > Inserting one workbook into another as a linked object is an unusual > thing to do. If you double-click it, it will open up the source [quoted text clipped - 5 lines] > MVP - Microsoft Excel, Oxford, England > No email replies please - respond to newsgroup You are right - when you import an object you see a picture of that object. When you double-click it then it will open. The normal way to view data from multiple sheets is to use formula links to important cells in those sheets (e.g. if there is a cell giving the date it was last updated or % complete etc). Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup Ok. Last question... I agree with that method of linking cells... but lets pretend for a moment that none of this was important... lol How can i control the size of a viewable object (other than grips) when inserted into an excel spreadsheet? If I can just figure that out - i win!! Cheers! BTW Thanx for your input Bill! J. > You are right - when you import an object you see a picture of that > object. When you double-click it then it will open. [quoted text clipped - 6 lines] > MVP - Microsoft Excel, Oxford, England > No email replies please - respond to newsgroup I don't know of a way. A few experiments have convinced me that Excel decides how big the picture should be when it has seen what is in the source worksheet. If the used range is smaller than its initial choice of size then it will downsize the picture to that used range. If the used range is bigger it may upsize the picture, but there is presumably some limit. If you specify Width and Height in the OLEObjects.Add method they have no effect on what Excel does. So the only way you might control it is by changing what appears on the source sheet I think you lose, but if you find a way of winning, please share it. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup Hi, Just caught up on this interesting thread. Have you tried using the Camera tool button? (Its a bit hard to find, customise a toolbar and look about 2/3rds down in the Tools category) With this button you can select a range in any sheet, take a picture and embed that in another sheet. The picture is linked and will change when the data in the original sheet changes. Ed Ferrero http://edferrero.m6.net |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.