Excel 2007 weird cond formatting loss in some conditions w/DDE links

J

Joe

Hi. I have experienced a weird and serious loss of data while
converting a financial spreadsheet from Excel 2003 to Excel 2007.

I have a lot of conditional formatting in that sheet, and about 100
DDE links that works with a stock quote feed.

After the conversion to v. 2007, everything was still there, but I
kept losing all the conditional formatting data after closing and
re-starting the spreadsheet (never while working on it). This problem
repro'ed 100% of the time in the same conditions..

After a lot of trials and errors, I finally enabled the "Prompt user
on automatic update for Workbook Links " and that seems to have fixed
the problem (for now?). The previous setting was "Enable automatic
update for all Workbook Links (not recommended) "

So it seems fixed, but still makes little sense to me. The 2003
spreadsheet is tried-and-true on the exact same machine and setup
(same data links), and I never before experienced such a loss of data
with Excel 2003.

I did some research, looked up manuals, Google, newsgroups etc.. and
can't find any references to a bug(s) that will nuke the cond
formatting data.

Any suggestions or hard info would be most welcome. Thanks in advance
for the help.

Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top