Home

PIVOT TABLE AND (MORE GENERALLY) MICROSOFT OFFICE PROBLEM

%3CLINGO-SUB%20id%3D%22lingo-sub-843890%22%20slang%3D%22en-US%22%3ERe%3A%20PIVOT%20TABLE%20AND%20(MORE%20GENERALLY)%20MICROSOFT%20OFFICE%20PROBLEM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-843890%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20has%20something%20new%20which%20is%20called%20Data%20types.%20Currently%20only%20two%20types%20exist%3A%20Geography%20or%20Stocks%20data%20type.%20With%20the%20Geography%20and%20Stock%20data%20type%20you%20really%20pull%20in%20a%20lot%20of%20data%20into%20a%20single%20cell.%20To%20get%20individual%20fields%20from%20such%20a%20cell%20you%20type%20%3DE2.Population%20to%20get%20the%20number%20of%20people%20in%20a%20country%20(for%20instance).%20%3CBR%20%2F%3EThe%20syntax%20e2.e32%20actually%20means%20that%20you%20want%20to%20get%20a%20field%20named%20%22e32%22%20from%20a%20data%20type%20in%20cell%20E2.%20Because%20there%20is%20no%20such%20field%20in%20cell%20E2%20(and%20because%20cell%20E2%20does%20not%20have%20a%20data%20type%20assigned%20to%20it)%2C%20you%20get%20a%20%23FIELD%20error.%20Fix%20this%20by%20using%20%3DSUM(E2%3AE32)%3C%2FP%3E%0A%3CP%3EALso%20you%20wrote%20that%20%22%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20font-family%3A%20'SegoeUI'%2C'Lato'%2C'Helvetica%20Neue'%2CHelvetica%2CArial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3EToday%20suddenly%20all%20my%20Excel%20financial%20files%20switched%20to%20pivot%20table%3C%2FSPAN%3E%22.%20Can%20you%20perhaps%20show%20us%20a%20screen-shot%20of%20what%20you%20mean%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842886%22%20slang%3D%22en-US%22%3EPIVOT%20TABLE%20AND%20(MORE%20GENERALLY)%20MICROSOFT%20OFFICE%20PROBLEM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842886%22%20slang%3D%22en-US%22%3E%3CP%3EPIVOT%20TABLE%20(AND%20OFFICE)%20PROBLEM%3C%2FP%3E%0A%3CP%3EToday%20suddenly%20all%20my%20Excel%20financial%20files%20switched%20to%20pivot%20tables%2C%20and%20when%20I%20open%20Word%20to%20write%20this%20memo%20the%20top%20is%20different%20than%20before%3A%26nbsp%3B%20top%20line%20is%20AutoSave%20followed%20by%205%20symbols%20unfamiliar%20to%20me.%26nbsp%3B%20I%E2%80%99ve%20used%20Office%20for%20decades%20and%20never%20had%20such%20a%20change%20before.%26nbsp%3B%20With%20pivot%20tables%20I%20can%20no%20longer%20sum%20a%20series%20of%20numbers%20in%20a%20column%2C%20for%20example%20%3CSTRONG%3E%3CEM%3E%3Dsum(e1.e32)%3C%2FEM%3E%3C%2FSTRONG%3E%26nbsp%3B%26nbsp%3B%20If%20I%20try%20this%20I%20get%20%3CSTRONG%3E%3CEM%3E%23FIELD!%20%3C%2FEM%3E%3C%2FSTRONG%3Ewhich%20is%20meaningless%20to%20me.%26nbsp%3B%20And%20I%20can%20no%20longer%20put%20a%20comment%20on%20a%20cell%20with%20a%20red%20marker%20in%20the%20upper%20right%20hand%20corner%20of%20the%20cell.%26nbsp%3B%20I%20don%E2%80%99t%20see%20how%20I%20could%20have%20unwittingly%20made%20this%20change%20in%20Office%2C%20both%20to%20Excel%20and%20Word%20%E2%80%93%20can%20you%20help%3F%26nbsp%3B%20Have%20I%20somehow%20been%20hacked%3F%3C%2FP%3E%0A%3CP%3EI%E2%80%99m%20Robert%20Valtz%2C%20in%20France.%20I%E2%80%99d%20be%20happy%20to%20give%20someone%20on-line%20access%20to%20my%20computer%2C%20a%20Dell%20Latitude%207280.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-842886%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPIVOT%20TABLE%20PROBLEM%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
RCKVM
Occasional Visitor

PIVOT TABLE (AND OFFICE) PROBLEM

Today suddenly all my Excel financial files switched to pivot tables, and when I open Word to write this memo the top is different than before:  top line is AutoSave followed by 5 symbols unfamiliar to me.  I’ve used Office for decades and never had such a change before.  With pivot tables I can no longer sum a series of numbers in a column, for example =sum(e1.e32)   If I try this I get #FIELD! which is meaningless to me.  And I can no longer put a comment on a cell with a red marker in the upper right hand corner of the cell.  I don’t see how I could have unwittingly made this change in Office, both to Excel and Word – can you help?  Have I somehow been hacked?

I’m Robert Valtz, in France. I’d be happy to give someone on-line access to my computer, a Dell Latitude 7280.

1 Reply

Excel has something new which is called Data types. Currently only two types exist: Geography or Stocks data type. With the Geography and Stock data type you really pull in a lot of data into a single cell. To get individual fields from such a cell you type =E2.Population to get the number of people in a country (for instance).
The syntax e2.e32 actually means that you want to get a field named "e32" from a data type in cell E2. Because there is no such field in cell E2 (and because cell E2 does not have a data type assigned to it), you get a #FIELD error. Fix this by using =SUM(E2:E32)

ALso you wrote that "Today suddenly all my Excel financial files switched to pivot table". Can you perhaps show us a screen-shot of what you mean?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies