Search results

Hi Narayan, Do you know if Excel "behave" differently depending the operating system of the computer? We have some computers here that are on a 32-bit and some on 64-bit operating system (mine is on a 32-bit), and what I found is that this particular report of mine does not seem to work on...

Hi Narayan, The file is saved on a network drive and they just open it from there. Thanks, Trang

Hi, Here's the link to my upload file. https://skydrive.live.com/redir?resid=85C1FFDA21CCCF48!107&authkey=!AFHQSZXF0Ut9Yyw Please note that I have changed the range names and file name so it's different to my original post, thinking that there may be something wrong with the name I...

Sorry Hui, that is a typo on my part. We are all using Excel 2007.

Narayan - sorry but I can't upload my workbook due to the nature of the information in it. Hui - the raw data is on another worksheet in the same workbook. I've just gone around and open the same workbook from different computers and have found that it works on some computers and not on...

Just got one of my colleagues to open the workbook again. When they open the workbook, the range definitions are as posted above but the series definitions are blank/empty on the formula bar. The chart that is shown on her screen is the chart from when I last saved the file. Date formats are...

In Name Manager I have: ChartLabel=OFFSET(Calculations!$D$27,0,0,1,Calculations!$C$13) ChartData=OFFSET(Calculations!$D$28,0,0,1,Calculations!$C$13) ChartAvg=OFFSET(Calculations!$D$29,0,0,1,Calculations!$C$13) Chart data I have: =SERIES(Calculations!$C$28,'Report for weekly sales...

I've created a chart that changes as the data in the named range changes. However, this only works when I open the workbook on my computer. When someone else opens the workbook on their computer, the data in the named range changes as the user changes the selection criteria (e.g. if they change...