hi,
I have powerpoint graphs linked to excel and some vba code to update excel from the database.
I am facing a few problems with the whole process and need help.
One, Since the links from powerpoint to excel are absolute; anytime there is a line in excel with no data it shows up in the powerpoint legend as a 0 value. How do i fix the legend or get rid of the lines in the powerpoint data sheet.
Secondly, I want to break the links from powerpoint to excel once the powerpoint has been updated. Is there a way to do this in vba.
Thirdly, I use this process to create a number of reports every month and what is happening is that after updating the graphs show the correct data but when i click open the graphs to see the data it shows the data of one of the other reports that i had prepared. ( even on a machine that does not have the driver excel on it).
And lastly, does anyone know why excel files keep growing in size as we keep changing and saving them even if the data contents do not change that much. Is there a way to bring the excel back to its original size.
thanks a lot for your help.
Rajeev
I have powerpoint graphs linked to excel and some vba code to update excel from the database.
I am facing a few problems with the whole process and need help.
One, Since the links from powerpoint to excel are absolute; anytime there is a line in excel with no data it shows up in the powerpoint legend as a 0 value. How do i fix the legend or get rid of the lines in the powerpoint data sheet.
Secondly, I want to break the links from powerpoint to excel once the powerpoint has been updated. Is there a way to do this in vba.
Thirdly, I use this process to create a number of reports every month and what is happening is that after updating the graphs show the correct data but when i click open the graphs to see the data it shows the data of one of the other reports that i had prepared. ( even on a machine that does not have the driver excel on it).
And lastly, does anyone know why excel files keep growing in size as we keep changing and saving them even if the data contents do not change that much. Is there a way to bring the excel back to its original size.
thanks a lot for your help.
Rajeev
