I
Ilya Barskiy
So, in the course of business, we routinely do the following:
Create a chart in Excel, Name the chart Range, insert it as a link into Word
documents.
After "upgrading" to SP3, this functionality is severely broken, creating
RC-style references in the pasted link, which simply will not do (this way,
manipulating the chart in Excel necessitates re-pasting, which, with the
amount of work done, is ridiculously laborious - we're talking 200+ links per
document which routinely get modified).
There is no KB on this issue. Can somebody knowledgeable comment on what's
going on.
Mind you, I can get on board with the thought that we're going to get rid of
labels (vs. named ranges) - explicit definitions are always best, but I see
no reason for this change.
And as much as I care about and understand security, the decision to disable
format support in SP3 for security's sake is really stupid in the enterprise
environment where old documents get retained and cross-referenced on a
routine basis. At least make it a dialog like Macros in excel or something.
That would be a much better way to go.
Can somebody from MS or an MVP please comment. Obviously the real question
is the linking, I am just venting re: format parsing.
Create a chart in Excel, Name the chart Range, insert it as a link into Word
documents.
After "upgrading" to SP3, this functionality is severely broken, creating
RC-style references in the pasted link, which simply will not do (this way,
manipulating the chart in Excel necessitates re-pasting, which, with the
amount of work done, is ridiculously laborious - we're talking 200+ links per
document which routinely get modified).
There is no KB on this issue. Can somebody knowledgeable comment on what's
going on.
Mind you, I can get on board with the thought that we're going to get rid of
labels (vs. named ranges) - explicit definitions are always best, but I see
no reason for this change.
And as much as I care about and understand security, the decision to disable
format support in SP3 for security's sake is really stupid in the enterprise
environment where old documents get retained and cross-referenced on a
routine basis. At least make it a dialog like Macros in excel or something.
That would be a much better way to go.
Can somebody from MS or an MVP please comment. Obviously the real question
is the linking, I am just venting re: format parsing.