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
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