defaults

Whenever I create a Pivot Table I inevitably have to change the calculations in the table from Count to Sum, is there a way to program it so that it defaults to Sum?

Hi, I have encountered the strangest error in Excel and I hope someone can help. I have a form with a lot of VBA code to set defaults, hide rows, etc. I find that at times, if I have other spreadsheet open, the VBA code does not run. This means defaults do not get set and so on. Has anyone...

Hi, never had a problem until upgraded to Windows 10: I have a spreadsheet containing a column of dates in mmm-yy format. eg Jun-17 but when I enter Jun-17, Excel defaults to Jun-18. Same thing happens If I enter Jun-19, it just defaults to Jun-18. Can anyone Help? I am using Office 2013.

Why isn't my name box working? For example, I highlight A1:B2, the name box briefly displays "2R X 2C", but as soon as I click on the name box to define the range, it defaults back to A1. If I've created a list of named ranges, when I click the drop down menu of the name box, it displays the...

Embarrassing, but I have a report due tomorrow and all I havve remaining is typing the links in the cells. The range I'm using has the text formatted to Georgia 9.5px (black)... I do not mind the hyperlinks turning blue, in fact, I expected it; However, the cell sizes do not accommodate...

HI I would like to change the default format for when I push the comma style button on the ribbon. At the moment, it does two decimal places and negative numbers beginning with a dash. I would like to reformat this so it does not give decimal places and the negative numbers appear in...