Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't Filter in Excel 2003
I am opening a file that opens in Internet Explorer as an Microsoft Excel
spreadsheet. I have microsoft excel 2003 installed on my machine. When I try and choose Data-Filter, this option is greyed out and I can't filter my data. However, if I save the spreadsheet and then open it directly in Excel, I can filter the data. Any ideas? When others open the file it opens it in Internet Explorer as an Excel spreadsheet and they can choose the filter option. Is there a setting on this? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't Filter in Excel 2003
Save the file to your desktop or mydocs and then open it. You should be able
to filter from there Frank "duketter" wrote: I am opening a file that opens in Internet Explorer as an Microsoft Excel spreadsheet. I have microsoft excel 2003 installed on my machine. When I try and choose Data-Filter, this option is greyed out and I can't filter my data. However, if I save the spreadsheet and then open it directly in Excel, I can filter the data. Any ideas? When others open the file it opens it in Internet Explorer as an Excel spreadsheet and they can choose the filter option. Is there a setting on this? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't Filter in Excel 2003
Yes, that works, but I am wondering why I have to save it first to do this,
while the others it works fine (they can choose the filter option). I also can't click on the tools options. I shouldn't have to save it first. "Frank Pytel" wrote: Save the file to your desktop or mydocs and then open it. You should be able to filter from there Frank "duketter" wrote: I am opening a file that opens in Internet Explorer as an Microsoft Excel spreadsheet. I have microsoft excel 2003 installed on my machine. When I try and choose Data-Filter, this option is greyed out and I can't filter my data. However, if I save the spreadsheet and then open it directly in Excel, I can filter the data. Any ideas? When others open the file it opens it in Internet Explorer as an Excel spreadsheet and they can choose the filter option. Is there a setting on this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an Excel 2003 Advanced Filter Bug?! | Excel Discussion (Misc queries) | |||
Excel 2002/2003 Advanced Filter | Setting up and Configuration of Excel | |||
Excel 2003 doesn't filter correctly | Excel Discussion (Misc queries) | |||
need pcx graphics filter for excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Filter Problem | Excel Discussion (Misc queries) |