Damn You Excel

Message Bookmarked
Bookmark Removed
Not all messages are displayed: show all messages (15 of them)

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 (one year ago) link

Have you tried using pivot tables?

jmm, Wednesday, 2 November 2022 16:05 (one year 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 (one year ago) link

are u using Windows? maybe it needs to install stupid updates

sarahell, Wednesday, 2 November 2022 19:23 (one year 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 (one year ago) link

you should def upgrade from 1988 version for mac

sarahell, Wednesday, 2 November 2022 19:53 (one year ago) link

NOW YOU TELL ME! Freak this floppy desk!

| (Latham Green), Thursday, 3 November 2022 17:16 (one year ago) link

never update from 1988 Mac

death generator (lukas), Thursday, 3 November 2022 18:27 (one year 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 (one year ago) link

"paste values" is your friend

blissfully unawarewolf (Ye Mad Puffin), Friday, 4 November 2022 16:54 (one year ago) link

this is whispered as if a runic secret

| (Latham Green), Friday, 4 November 2022 17:32 (one year ago) link

one month passes...

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 (one year ago) link

keep reading this as "Damn, You Excel!"

partez Maroc anthem (Noodle Vague), Tuesday, 27 December 2022 16:16 (one year 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
in the Immediate window.

anatol_merklich, Wednesday, 4 January 2023 23:00 (one year ago) link

one month passes...

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


You must be logged in to post. Please either login here, or if you are not registered, you may register here.