u/r2barrera

Onenote for Windows 10 used to be my second favorite app. Since it is now deprecated (made read only), I need to use Onenote desktop, which has a lot of limitations, at least as to math – latex capabilities. Now one more headache has popped up which makes onenote desktop practically useless. As shown in the attached image, I can see only the first character of the page list, I cannot expand it! I consulted copilot for a couple of hours, nothing worked. Copilot finally said I should uninstall and then re-install onenote. The problem persisted. Copilot suggested I uninstall and then reinstall office 365. The problem persisted. I finally asked Copilot to provide me the phone number to Technical assistance where I could talk to a human being. Copilot provided a phone number with a small script as to what I should tell the technician. I called the number, a robot ask me to describe the problem, I basically read the script, and then I was given links to web pages where different onenote problems were discussed!

Help! I need onenote!

· Can anyone make any suggestions as to how to be able to make onenote normal, i.e. allowing me to be able to read the page listing panel?

· Can anyone give me a phone number to Microsoft support where I can talk to a human being?

Hi hope someone can help with my excel subtotals questions. I use excel 365. I took great pains to scrape a table from the web. It has about 450 rows and 15 columns. I used slicers and column headings to filter the data so that I can see patterns. Subtotal works inconsistently. If I use the formula:

=SUBTOTAL(101,[MDIST])

I get a correct answer ( the mean distance of the orbital distances of a selected planet’s moon). Note [MDIST] is the name of the header. However if I try to get the minimum distance of a selected planet’s moons, the following does not work:

=SUBTOTAL(105,[MDIST])

This renders the minimum distance of all the moons, given all the planets. In other words structured references work for average, but not for minimum. If I manually select the [MDIST] column and type =SUBTOTAL(105,E9:E428), I get the correct answer. This is annoying because I have to manually select distance (and other columns I have not mentioned) each time I select a different planet or dwarf planet. Is there a way to automate this process?

Second question: Is there a way to freeze the column headers as I scroll deep down in my database?

Can't read page list panel on Onenote!

Problems with subtotals with filtered data, works only sometimes.