Inventor General Discussion

Inventor General Discussion

Reply
*Mung, George
Message 1 of 2 (54 Views)

Changing range in linked Excel stock list

54 Views, 1 Replies
12-04-2002 11:52 PM
Ok I changed it to a pasted link to the external spreadsheet - that way it
looks like I now can right click on the spreadsheet in the IDW and get a
"Change Source" option. Then in a box in the open file dialogue, it looks
like you can change the range and even the sheet number. So I added a line
in row 41, inside Excel. When I go to change the range in the open file
dialogue from:
Sheet1!R1C1:R40C9
to
Sheet1!R1C1:R41C9
it tells me " Invalid Source: Do you want to correct it?" So I say yes. Well
then nothing changes. I thought, "well, ok maybe it needs to see me change
to a different file name", so I copied the file to another and no luck. So I
make sure the files are saved and Excel is closed - still no luck. I am
posting a sample IDW and Spreadsheet in CF for people with way too much time
on
their hands to try this and see if they can figure out what I'm doing wrong.
Thanks!
*Mung, George
Message 2 of 2 (54 Views)

Re: Changing range in linked Excel stock list

12-05-2002 12:17 AM in reply to: *Mung, George
Nevermind - this is a total dead end, since it won't save out to an AutoCAD
drawing - another of my client's requirements. Worthless.

Won't save out if it's an embedded spreadsheet either.
Won't paste special as a dumb Picture Metafile or bitmap (dumb meaning
updates aren't reflected).

It's moments like these when you have to bite your tongue and appreciate
what you DO have. At least AIS comes with a copy of AutoCAD.


"George Mung" wrote in message
news:44B033F3349B06C9D162E234707C3352@in.WebX.maYIadrTaRb...
> Ok I changed it to a pasted link to the external spreadsheet - that way it
> looks like I now can right click on the spreadsheet in the IDW and get a
> "Change Source" option. Then in a box in the open file dialogue, it looks
> like you can change the range and even the sheet number. So I added a line
> in row 41, inside Excel. When I go to change the range in the open file
> dialogue from:
> Sheet1!R1C1:R40C9
> to
> Sheet1!R1C1:R41C9
> it tells me " Invalid Source: Do you want to correct it?" So I say yes.
Well
> then nothing changes. I thought, "well, ok maybe it needs to see me change
> to a different file name", so I copied the file to another and no luck. So
I
> make sure the files are saved and Excel is closed - still no luck. I am
> posting a sample IDW and Spreadsheet in CF for people with way too much
time
> on
> their hands to try this and see if they can figure out what I'm doing
wrong.
> Thanks!
>
>
>
>
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.