Subtotals in excel XP

alizok

Board Regular
Joined
Sep 12, 2002
Messages
88
Office Version
  1. 365
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

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
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?
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,217,479
Messages
6,136,899
Members
450,029
Latest member
MissQuotation

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
Back
Top