Hi all,
[Still exploring the possibility to migrate from Lotus Millennium ...]
1st problem:
I copied a list of shares in Sheet1 of a new spreadsheet (ss) and
established a link to an url (which gives the latest quotation) in Sheet
2 of the same ss.
All works very nicely but ...
If I assign named ranges to each of the cells where the quotations are
and then add a new share (a new row) in the original URL table, when
sheet2 refreshes the link the new row disrupts the old ranges.
May be I found a way to avoid this: first insert a new blank row in
sheet 2 and then refresh the link, but perhaps there is a better way...
2nd problem:
When the link in sheet2 is refreshed, the new table will be copied on
the old one in such a way that this remains as a one-column table
underneath the freshly copied one: deletion of that column causes, of
course, the left shifting of all range names! [So, one reason more to
find a way to refer to a cell in another sheet (on the same ss) by range
name instead of by cell ref (ColumnRow)] (*)
Before doing the link-refresh I saved-closed the ss and re-opened it
answering 'yes, do refresh the link'. Didn't find a way to do that
without re-opening the file.
Thanks for your attention.
Regards,
Ennio.
(*) Should I file an 'rfe' in that respect?
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (�|�)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
