On May 11, 2:43*pm, Sarah wrote:
I have macros running in excel which massage data created by Live Office
(Business Objects Queries.) *Every time a macro tries to edit the data
returned by the query I am hounded by a message which says, "The value(s)that
came from a BusinessObjects Enterprise data source has just been
edited/deleted. *Do you want to proceed with the change?".

"With most popup messages I just use the displayalerts statement to get
around it. *That does not work for this message which specifically addresses
the Live Office edits. *Does anyone know how to suppress it. *I have
discovered that if the file created by the query is saved as an older version
of excel and then resaved it as the new version, the messages do not appear,
however it is a bit embarassing to have to ask a user to remember to execute
such a cluge.

Unfamiliar with Live Office, but the message sounds like that
application is somehow still linked/aware of the query so you need to
either look towards suppressing the message from that end, or since
saving the results and loading the resultant file instead seems to
work, consider implementing it within your routine.