search for: excel2007

I get the error, "Not enough system resources to display completely", when I zoom out below 80% on spreadsheets that have labeled charts. That is, any charts that have axis numbers, axis labels, or chart labels. If I keep the charts but delete all text, I can zoom out indefinitely without the error. If I navigate away from the chart with labels I am able to zoom out just fine. For some

I have installed Win 1.1.42 on Ubuntu10.04 and installed Excel2007 as part of MS Office 2007. I can open a non-password protected .xlsx file without a problem. However, when I try to open a password protected .xlsx file, I get an error message "The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct c...

I am reading dates in Excel2007 into R. Here are the functions I used: library(RODBC) channel<-odbcConnectExcel2007("myfile.xlsx") tmp<-sqlFetch(channel,"1",as.is=T) The dates in myfile.xlsx are all in this format: mm/dd/yyyy. But when I read it to R, some columns look like "yyyy-mm-dd 00:00:00&...

I have recently started a new job at an NHS hospital in Scotland. Since I took up this post 6 months ago I have had an ongoing dispute with the IT secutiry dept. who refuse to install R on my computer. I previously worked in another branch of the NHS where R was widely used and yet there is nothing I can say which will persuade the IT dept here to even visit the website! With some help from our