Biodiesel Posted September 17, 2012 Share Posted September 17, 2012 Currently i am trying to get an Excel sheet incorporated into my AutoCAD layout. I get it in and it seems way to small. I re-scale the excel insert and get it right then update the sheet to get the new info and it shrinks back down. Now i thought at first it was the excel insert that was the problem, but now looking my layout seems to be extremely large and that's why the excel sheet is off. How can i take my existing layout and change it to fit 11x17. I really don't want to have to redraw the whole layout to make it fit 11x17. Quote Link to comment Share on other sites More sharing options...
ReMark Posted September 17, 2012 Share Posted September 17, 2012 Did you size your layout via the Page Setup Manager? That's where you pop into the PLOT dialog box and select your paper size. Quote Link to comment Share on other sites More sharing options...
Biodiesel Posted September 17, 2012 Author Share Posted September 17, 2012 I didn't actually make the original layout. It was created before i started working here and i have no clue how it was done before. It was saved as a template and i have continued using it as is. Things that were done before me seem to be a bit odd, how files were saved and setup i have changed all i could to make things correct but this is one issue i don't know what to do. Quote Link to comment Share on other sites More sharing options...
ReMark Posted September 17, 2012 Share Posted September 17, 2012 What size paper was this particular layout supposed to print to? If you change the size of the paper then you will most likely have to edit the size of the border so it fits within the printable area. Quote Link to comment Share on other sites More sharing options...
Biodiesel Posted September 17, 2012 Author Share Posted September 17, 2012 The size im not sure of. I know right now it measures 187" x 119" but i print to tabloid / 11x17 pdf and then actually print to any page size i need, but im thinking because they layout is so large is the reason the excel sheet ends up being so small. So i want to take my current layout and make it sized to 11 x17 so when i import the excel sheet it fits correctly. Quote Link to comment Share on other sites More sharing options...
ReMark Posted September 17, 2012 Share Posted September 17, 2012 It seems like you scale the drawing "to fit" the paper size. Quote Link to comment Share on other sites More sharing options...
Biodiesel Posted September 17, 2012 Author Share Posted September 17, 2012 Id have to say yes to that, but how do i get my current layout scaled down to 11x17 paper that way i can use my excel sheet? Quote Link to comment Share on other sites More sharing options...
ReMark Posted September 17, 2012 Share Posted September 17, 2012 Please confirm that you are using a paper space layout with at least one viewport. Yes or No? Quote Link to comment Share on other sites More sharing options...
Biodiesel Posted September 17, 2012 Author Share Posted September 17, 2012 yes i am, i draw everything in model space and then go to the layout view and use viewports to display what i have drawn. Quote Link to comment Share on other sites More sharing options...
ReMark Posted September 17, 2012 Share Posted September 17, 2012 Are you inserting the spreadsheet into paper space? Are you making use of the Table > Data Link feature of AutoCAD 2012? Quote Link to comment Share on other sites More sharing options...
Biodiesel Posted September 17, 2012 Author Share Posted September 17, 2012 Yes i am, when im in paper space i go through the process of inserting the spreadsheet into AutoCAD on my paper space layout. Quote Link to comment Share on other sites More sharing options...
ReMark Posted September 17, 2012 Share Posted September 17, 2012 It sounds like you have to scale the spreadsheet UP when you insert it into your layout. Quote Link to comment Share on other sites More sharing options...
Biodiesel Posted September 17, 2012 Author Share Posted September 17, 2012 How do i do that i can't find any settings to scale it up, and after its inserted if i scale everything up then when i update the sheet it shrinks back down. Quote Link to comment Share on other sites More sharing options...
ReMark Posted September 17, 2012 Share Posted September 17, 2012 Have you tried the AutoCAD SCALE command? Quote Link to comment Share on other sites More sharing options...
Biodiesel Posted September 17, 2012 Author Share Posted September 17, 2012 Yes, that's how i scale it to fit but if i change any info on the excel sheet i have to go into AutoCAD and hit update sheet and when i do it scales it back down. Quote Link to comment Share on other sites More sharing options...
ReMark Posted September 17, 2012 Share Posted September 17, 2012 I have used the Data Link feature several times and I have never had a spreadsheet resize itself up or down. I'd have to test it. How big is this spreadsheet? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.