Subtotals in excel XP

alizok

Board Regular
Joined
Sep 12, 2002
Messages
76
I have just installed office xp professional on my computer. I am trying to work with a workbook that I have had no problems with while running office 2000 on windows 98. I
am trying to use subtotals, and when I apply the subtotal function my spreadsheet disappears.
Anyone else have this problem and know of a fix/patch/workaround?

Thank you in advance for your ideas.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

shades

Well-known Member
Joined
Mar 20, 2002
Messages
1,550
I use Office XP on Windows 2000 and have not experienced anything like that.

Is it only with subtotals? What about changing some to the other functions (average, etc.). Does it still happen?

What about other menu items, i.e. Group and Outline?
 

alizok

Board Regular
Joined
Sep 12, 2002
Messages
76
I tried using Window NT and I come up with the same problem. Actualy sometimes when I do Text to Column I come up accross a very strange erros cna't even explain. what strange is that it doesn't happen all the time but it does happen for sure. You can even check other group discussions and you'll notice people have the same problems.
Too bad I can't attache file so you could try it.
This message was edited by alizok on 2002-09-13 11:35
 

alizok

Board Regular
Joined
Sep 12, 2002
Messages
76
I actully was able to figure out the problem. o_O All you have to do is to make sure that your spreadsheet is set to automatic calculations. If it is manual it will give you an erro when you do text to column or when you try subtotal
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,021
Messages
5,834,992
Members
430,331
Latest member
Syed Yasir Hannan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top