I click an excel file to open - nothing happens. Only when I CLOSE excel does it open. Why?
― | (Latham Green), Wednesday, 2 November 2022 16:01 (two years ago) link
Have you tried using pivot tables?
― jmm, Wednesday, 2 November 2022 16:05 (two years ago) link
A leader once told me "Always choose a pivot chart with the pivot table - because then you get a chart"
as if I always want a chart
― | (Latham Green), Wednesday, 2 November 2022 18:29 (two years ago) link
are u using Windows? maybe it needs to install stupid updates
― sarahell, Wednesday, 2 November 2022 19:23 (two years ago) link
It is excel 2013
Also using Microsoft 265 crap excel-in-a-browser
Maybe need to update office to a more recent version
it is particular sad since excel is such a basic thing to use https://www.versionmuseum.com/images/applications/microsoft-excel/webp/microsoft-excel%5E1985%5Eexcel-for-mac-1.5-about.webp
― | (Latham Green), Wednesday, 2 November 2022 19:42 (two years ago) link
you should def upgrade from 1988 version for mac
― sarahell, Wednesday, 2 November 2022 19:53 (two years ago) link
NOW YOU TELL ME! Freak this floppy desk!
― | (Latham Green), Thursday, 3 November 2022 17:16 (two years ago) link
never update from 1988 Mac
― death generator (lukas), Thursday, 3 November 2022 18:27 (two years ago) link
I tried to put data from a pdf into excel and ended up with a bloody mess of clouds misaligning.
Now I try to remove dates from a column that is supposed to be middle initials - and failing at that beucase even though there are cells that cleaary start with 1 , it wll not select all that starts with 1
wtf
― | (Latham Green), Friday, 4 November 2022 16:40 (two years ago) link
"paste values" is your friend
― blissfully unawarewolf (Ye Mad Puffin), Friday, 4 November 2022 16:54 (two years ago) link
this is whispered as if a runic secret
― | (Latham Green), Friday, 4 November 2022 17:32 (two years ago) link
we keep having Excel files balloon over 400+ MB randomly at work. we know why - somehow, Excel thinks there are 10000+ rows/columns with data that don't have data in them.
but i can't figure out why. anybody know why Excel would randomly think blank cells had data, esp when everybody else using the same template (which is password protected) isn't having this problem?
― Fash Gordon (Neanderthal), Tuesday, 27 December 2022 16:08 (two years ago) link
keep reading this as "Damn, You Excel!"
― partez Maroc anthem (Noodle Vague), Tuesday, 27 December 2022 16:16 (two years ago) link
Neanderthal: Might something have accidentally been entered into a far-off cell at some point? In that case, removing that content, or even deleting the actual rows/columns themselves, unfortunately doesn't reset the limits of the sheets.
You could try the trick in this article: briefly, open up VBA and run the command
ActiveSheet.UsedRange
― anatol_merklich, Wednesday, 4 January 2023 23:00 (one year ago) link
pretty amazing to learn what lowly excel can do with a bit of google magic as far as the features noone usually uses but are incredibly powerful
― | (Latham Green), Monday, 6 February 2023 19:19 (one year ago) link