I learned of the list feature (which in 2007 is the Table feature) from this board & thought it would be the simplest solution to copying down formulas when inserting rows but I can't seem to get it to work. I haven't been able to find the reason in searches here & on the internet. Perhaps someone in this community can help? It would be much appreciated!
Thanks in advance!
I created a very standard pivot chart to try the new Slicer feature on excel 2010 but it is unhighlighted and doesn't allow me to select it.
I have a pivot chart taht has count of assets broken out to location filtering by model type...why wouldn't it allow me to select slicer tool?
I've tried other combinations but it won't allow me to select. I've saved it from a 2003-2007 spreadsheet to a macro enabled and it still won't allow me.
Any ideas why I might be able to use this feature?
Thanks!
Hello,
I am trying to create a dynamic chart of interest rates over a 10 year period (daily rate entries -- thus over 3000 lines of data) for 18 countries. Eventually, I want to use a filter or pulldown menu so that the user can choose which country will display in the chart. Rates are updated daily. I am trying to decide if I should use the Table feature in Excel 2007 or do this by naming ranges and using the offset function. Or perhaps a combination of both?
Any insight is much appreciated!
--GinGin
Hello Excel Guru's,
I am a long time listener, first time caller
So i was wondering if any of you guru could help me apply the auto-filtering feature in excel 2007 to excel 2002.
The obvious answer to the below question is why dont i just upgrade to 2007. And my obvious reply is i dont want to. I really dont like the new format and i only really want one new feature.
I want to do a basic filtering system that has check boxes.
For example in Column A i have values 1,2,3,4,5. I would like to view 1,3,5 and then view 2,4 for example. Currently 2002 only lets me view just 1 or just 3.
I only really need to do **** for column A so i dont see the need in doing a dynamic table.
On top of that would it be at all possible to have visible check boxes in the excel spread sheet. So have a check box next to 1,2,3,4,5 and then if they are unselected they get filtered out...that would be awesome.
Thanks for your time in reviewing this and to any responses.
Best
JJ
I have been looking for the database function that allows you to save a file as a template and then have other files feed information into it. I cannot locate this in 2003. I checked my add-ins etc and can't find it.
Any help would be appreciated.
The Autosave feature (add-in) available in earlier versions of Excel has been 'replaced' by the Autorecover feature in versions 2003+. The problem is, Autorecover DOES NOT perform the same function as Autosave did- it appears to be for 'crash protection' onle, i.e., saves your work when your system goes down unexpectedly. Does anyone know how to obtain the Autosave feature so that I can be sure my work is saved at specific intervals to a location that is user-specified? Also- am I missing something here? Autosave was an important function; why would MS not include it in recent versions?
Debra Dalgleish, if I understand correctly, suggests recording a small macro
to allow refreshing a protected pivot table.
But what is the point of the 'Tools, protect sheet, Use pivot table
reports' ? It seem to allow nothing.
How is it supposed to work or is my Excel faulty?
I turned the feature on. Then turned it off, but desppite turning it off it will not stop reading the cells.
Has anyone had this happen, how do I stop it?
I am trying to use the sub-total feature in Excel 2003. I have used it in
previous versions of excel, but in 2003 it is on the menu, but not available
for use.
I use Report Manager a lot in Excel 2000. I want to upgrade to Excel 2003 but
I dont see this in any feature lists. Is this feature not in Excel 2003?
