fontsmicrosoft excelmicrosoft-excel-2003microsoft-excel-2007
For cells containing hyperlinks the font changes automatically into the default one (even though I have selected all cells and applied a different font).
How can you configure Excel to use the same font face/size as you selected for the entire sheet (or group of cells) and not the default font set in Excel (in Excel 2007 the font can be set in Excel Options | Popular tab | When creating new workbooks section).
Yes. In Word, just click on the Insert tab, then in Text group click on Object. Then choose and existing file and make sure you click the checkbox that says Link to File. Like this:
You can then double-click on the object and the original will be updated once you push "Save" in the Excel app that opens up your XLSX. If you have the Excel document open seperately (meaning you didn't double-click on the object in Word) and update a cell, it won't get automatically updated in Word until either 1) you close and re-open Word or 2) press F9.
This can all be done programmatically as well.
I have the same issue as the original writer. And I also tried already all the things he did and none of them worked. Also I now checked the calculations options and that was automatic just as it's supposed to be. Everything else works and calculates fine but this one chart does not update when the data changes (and the data calculates with a special funcion that separates different colored numbers from another set of data).
I found a temporary solution and made a macro (and a button for that) which first updates the data similarly to Ctrl+Alt+F9 and then switches the rows of my chart to columns and then again columns to rows. Strange, but works.
I used this to switch them:
ActiveChart.PlotBy = xlColumns
ActiveChart.PlotBy = xlRows
Of course I would prefer to find out the real way to fix it but this has also worked so far...
Best Answer
You need to create a new default template that will load at startup. They didn't make it easy to do in Office 2007! But here's how:
Now whenever you start Excel or create a new workbook, the hyperlink font should be the one you choose.
This Microsoft support article helped me: http://support.microsoft.com/kb/822107 look here for where to save templates for Office 2003, or to see other ways of loading your template.