LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 231
Default Trying again for an answer.

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculator Answer Doesn't Match Excel Answer GwenH Excel Discussion (Misc queries) 3 October 20th 08 10:17 AM
=D6-E6. Answer in F6. I want answer in F6 only if value in E6? JillM Charts and Charting in Excel 1 July 21st 06 01:15 PM
Need An Answer To This! Turquoise_dax Excel Discussion (Misc queries) 11 June 13th 06 06:38 PM
please i need an answer fadi0007 Excel Worksheet Functions 1 December 24th 05 11:49 AM
i cant get the exact answer e.g answer is 13.49% i got 13.00% zai Excel Discussion (Misc queries) 3 June 9th 05 01:00 PM


All times are GMT +1. The time now is 11:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"