Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Losing data when saving to 2003 format
I use both Excel 2007 and 2003 on the same PC. I use the new cube function
in excel 2007 to return data to a worksheet and this data feeds a weekly report which is distributed to other users who only have excel 2003. So I have written some macros that update everything and then remove the cube formulas and save the report in 2003 format. This works fine on my PC and one of my colleagues. However, on another PC when the same macro is run and the workbook is saved to 2003 format there is a chart, whose data is linked via a named range (this named range is not the result of any formulas and is just two lists of turnover figures by week), and the reference to the source data is completely gone - there is a chart there but it is completely blank. As I said it works fine on 2 PC's but on the 3rd the source data for this chart gets lost. This problem has baffled everyone I have spoken to (and in our IT dept). Has anyone else encountered anything similar. Thanks for taking the time. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Losing data when saving to 2003 format
Graham Whitehead wrote:
I use both Excel 2007 and 2003 on the same PC. I use the new cube function in excel 2007 to return data to a worksheet and this data feeds a weekly report which is distributed to other users who only have excel 2003. So I have written some macros that update everything and then remove the cube formulas and save the report in 2003 format. This works fine on my PC and one of my colleagues. However, on another PC when the same macro is run and the workbook is saved to 2003 format there is a chart, whose data is linked via a named range (this named range is not the result of any formulas and is just two lists of turnover figures by week), and the reference to the source data is completely gone - there is a chart there but it is completely blank. As I said it works fine on 2 PC's but on the 3rd the source data for this chart gets lost. This problem has baffled everyone I have spoken to (and in our IT dept). Has anyone else encountered anything similar. Thanks for taking the time. First thing to do is check the SP patch levels of the different XL2007 versions. I have seen enough madness with 2007 to be very suspicious when the same code on different machines gives different behaviour. XL2007 charting sucks so it would be no surprise if there were bugs that could make entire graphs vanish. Good luck - you will need it. Regards, Martin Brown |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge cells without losing data OR format | Excel Discussion (Misc queries) | |||
Losing date format when saving .csv files | Excel Discussion (Misc queries) | |||
Saving Excel 2003 file in .txt format | Excel Discussion (Misc queries) | |||
How do I change date format without losing data? | New Users to Excel | |||
saving dbf file without losing data | Excel Discussion (Misc queries) |