# Dumb Excel Questions **URL:** \ **Category:** Software/Technology\ **Created:** [February 3, 2022, 6:03pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148 "2022-02-03T18:03:06Z")\ **Posts on this page:** 20\ **Page:** 9
**Author:** ![Rastiln](https://community.goactuary.com/user_avatar/community.goactuary.com/rastiln/32/77682_2.png) [@Rastiln](https://community.goactuary.com/u/Rastiln)\ **Post date:** [January 29, 2024, 4:02pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/164 "2024-01-29T16:02:50Z")
It could be evidence of corruption. I recently had to remake an entire workbook from scratch in a new file. And linked workbooks seem to one of the most frequent causes of corruption in my experience. Probably the only thing I’ve seen cause more corruption is programmatically opening and modifying invisible instances of Excel. (No idea WHY that ruined so many workbooks but it did.) ---
**Author:** ![DeepPurple](https://community.goactuary.com/user_avatar/community.goactuary.com/deeppurple/32/1551_2.png) [@DeepPurple](https://community.goactuary.com/u/DeepPurple)\ **Post date:** [January 29, 2024, 4:03pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/165 "2024-01-29T16:03:36Z")
> [@Rastiln](#): > > I have a workbook with another linked workbook. If I made a list of top 10 things that I hate when people do in Excel, this would be on it, somewhere in the middle. 10, 9, 8, 7. 6. 5. Links to outside workbooks. 4. 3. 2. What I call “Pinball Logic” \* 1, Nested IF statements - Pinballing is what I call it when the logic (and cell referencing) flows left and right and up and down within a spreadsheet. Well designed spreadsheets work linearly left to right or top to bottom. ---
**Author:** ![Rastiln](https://community.goactuary.com/user_avatar/community.goactuary.com/rastiln/32/77682_2.png) [@Rastiln](https://community.goactuary.com/u/Rastiln)\ **Post date:** [January 29, 2024, 4:04pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/166 "2024-01-29T16:04:37Z")
I just gotta work with what I have. And that is multiple outside linked workbooks. To be fair, keeping it all in one workbook would be stretching the capabilities of Excel. This input data should all be stored in SQL somewhere but that’s for me to solve in a future quarter when I have time. I definitely work with pinball data. “So this is calculated in a second workbook.. then pulled into this one… but you’re then also calculating the data from the same inputs here…” I’m doing a lot of refactoring. ---
**Author:** ![SteveGrondin](https://community.goactuary.com/user_avatar/community.goactuary.com/stevegrondin/32/3257_2.png) [@SteveGrondin](https://community.goactuary.com/u/SteveGrondin)\ **Post date:** [January 29, 2024, 4:05pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/167 "2024-01-29T16:05:54Z")
I avoid linked workbooks because they scare me. Most of the heavy-lifting workbooks I create/use use connections to SQL. Starting to lean PowerBI. ---
**Author:** ![1695814](https://community.goactuary.com/user_avatar/community.goactuary.com/1695814/32/38506_2.png) [@1695814](https://community.goactuary.com/u/1695814)\ **Post date:** [January 29, 2024, 4:05pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/168 "2024-01-29T16:05:55Z")
> [@DeepPurple](#): > > 3 1. Merged cells ---
**Author:** ![Rastiln](https://community.goactuary.com/user_avatar/community.goactuary.com/rastiln/32/77682_2.png) [@Rastiln](https://community.goactuary.com/u/Rastiln)\ **Post date:** [January 29, 2024, 4:06pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/169 "2024-01-29T16:06:27Z")
What, did you want to use VBA on your workbook EVER? Sorry, it has a merged cell. ---
**Author:** ![DeepPurple](https://community.goactuary.com/user_avatar/community.goactuary.com/deeppurple/32/1551_2.png) [@DeepPurple](https://community.goactuary.com/u/DeepPurple)\ **Post date:** [January 29, 2024, 4:06pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/170 "2024-01-29T16:06:30Z")
> [@1695814](#): > > Merged cells List addition APPROVED! ---
**Author:** ![twig93](https://community.goactuary.com/user_avatar/community.goactuary.com/twig93/32/527_2.png) [@twig93](https://community.goactuary.com/u/twig93)\ **Post date:** [January 29, 2024, 4:14pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/171 "2024-01-29T16:14:19Z")
A colleague referred to one process involving a bunch of linked workbooks as “a series of Excel spreadsheets duct taped together” which was apt. I had been making the argument for years that we needed something better. At one point I demonstrated to auditors how easy it would be for me to defraud the company of millions of dollars due to these spreadsheets. They were unmoved. I think about 15 years after my initial push they finally did something more secure and robust with them. I was no longer with the company. ---
**Author:** ![dr\_t\_non-fan](https://community.goactuary.com/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dr\_t\_non-fan](https://community.goactuary.com/u/dr_t_non-fan)\ **Post date:** [January 29, 2024, 4:45pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/172 "2024-01-29T16:45:58Z")
> [@Rastiln](#): > > I have a workbook with another linked workbook. Stop right there. While it seems like an awesome tool in Excel, it is not. It’s a “sex machine” as the recent NSFW GIF stated. ---
**Author:** ![Rastiln](https://community.goactuary.com/user_avatar/community.goactuary.com/rastiln/32/77682_2.png) [@Rastiln](https://community.goactuary.com/u/Rastiln)\ **Post date:** [January 29, 2024, 4:52pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/173 "2024-01-29T16:52:07Z")
Hey, give me a week and I’ll rework this all into a better solution. As it stands I just need to cobble together some shit that functions for this go-round. ---
**Author:** ![SteveGrondin](https://community.goactuary.com/user_avatar/community.goactuary.com/stevegrondin/32/3257_2.png) [@SteveGrondin](https://community.goactuary.com/u/SteveGrondin)\ **Post date:** [January 29, 2024, 5:19pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/174 "2024-01-29T17:19:09Z")
I do wonder about your “about to go corrupt” guess. I had a workbook that was linked to a tabular SQL database that was doing squirrelly stuff. After fiddling with it to try to get what I needed, it finally acknowledged it was corrupt. If that’s the case, you might not be able to delay improving the process. One other approach I inherited and works ok. Large segmented data (multiple copies of same data for x segments), lots of formulas to apply segment by segment. 1 Formula workbook, multiple data workbooks. Macro opens formula wkbk, 1 of the data wkbk, copies in data, computes formulas, save formula wkbk as unique to segment name, repeat. The formula wkbk has summary ranges, and summary ranges saved to aggregate workbook. Reviewers like the ability to examine any detail element. ---
**Author:** ![Rastiln](https://community.goactuary.com/user_avatar/community.goactuary.com/rastiln/32/77682_2.png) [@Rastiln](https://community.goactuary.com/u/Rastiln)\ **Post date:** [February 9, 2024, 8:24pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/175 "2024-02-09T20:24:57Z")
Okay I don’t know if this is answerable But WHYYYYY does Excel freeze at something basic like “Please close this workbook without saving”?? I have one workbook that needs another open for me to develop in it. But when I try to save the first workbook with the second still open, or close the second so I can save the first, they just freeze and spin… After 4 crashes I’m just letting it run over the weekend to see if it saves. ---
**Author:** ![ALivelySedative](https://community.goactuary.com/user_avatar/community.goactuary.com/alivelysedative/32/1337_2.png) [@ALivelySedative](https://community.goactuary.com/u/ALivelySedative)\ **Post date:** [February 12, 2024, 12:54pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/176 "2024-02-12T12:54:38Z")
:popcorn: ---
**Author:** ![NormalDan](https://community.goactuary.com/user_avatar/community.goactuary.com/normaldan/32/1013_2.png) [@NormalDan](https://community.goactuary.com/u/NormalDan)\ **Post date:** [February 12, 2024, 12:59pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/177 "2024-02-12T12:59:56Z")
I usually project a persona onto excel which helps me cope with its antics. Sometimes excel is having a bad day and/or mad at me for all the things I made it do. ---
**Author:** ![Rastiln](https://community.goactuary.com/user_avatar/community.goactuary.com/rastiln/32/77682_2.png) [@Rastiln](https://community.goactuary.com/u/Rastiln)\ **Post date:** [February 12, 2024, 1:01pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/178 "2024-02-12T13:01:30Z")
It finally saved after saving from about 2:30-6:30 and I called it good, I no longer have to interact with the Demon Workbook. ---
**Author:** ![NormalDan](https://community.goactuary.com/user_avatar/community.goactuary.com/normaldan/32/1013_2.png) [@NormalDan](https://community.goactuary.com/u/NormalDan)\ **Post date:** [February 12, 2024, 1:11pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/179 "2024-02-12T13:11:04Z")
Maybe the workbook had just found out her husband was sleeping with his secretary!? ---
**Author:** ![Rastiln](https://community.goactuary.com/user_avatar/community.goactuary.com/rastiln/32/77682_2.png) [@Rastiln](https://community.goactuary.com/u/Rastiln)\ **Post date:** [February 12, 2024, 1:29pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/180 "2024-02-12T13:29:16Z")
RNN Unless this is a deep cut to me posting about my neighbor who cheated with his secretary like 2 years ago, in which case, impressive memory ---
**Author:** ![NormalDan](https://community.goactuary.com/user_avatar/community.goactuary.com/normaldan/32/1013_2.png) [@NormalDan](https://community.goactuary.com/u/NormalDan)\ **Post date:** [February 12, 2024, 1:37pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/181 "2024-02-12T13:37:38Z")
I’m definitely not that impressive.. just trying overly hard to project an amusing persona onto your excel ---
**Author:** ![Vorian\_Atreides](https://community.goactuary.com/user_avatar/community.goactuary.com/vorian_atreides/32/65623_2.png) [@Vorian\_Atreides](https://community.goactuary.com/u/Vorian_Atreides)\ **Post date:** [February 12, 2024, 2:56pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/182 "2024-02-12T14:56:31Z")
Have you tried uninstalling and reinstalling the application? ---
**Author:** ![DeepPurple](https://community.goactuary.com/user_avatar/community.goactuary.com/deeppurple/32/1551_2.png) [@DeepPurple](https://community.goactuary.com/u/DeepPurple)\ **Post date:** [February 12, 2024, 7:49pm UTC](https://community.goactuary.com/t/dumb-excel-questions/5148/183 "2024-02-12T19:49:25Z")
Have you tried turning it off and turning it back on again? ![image](https://community.goactuary.com/uploads/default/original/3X/4/d/4d133ae7dcc4c2766cad3f76e878180811130dda.jpeg) [Previous page](https://community.goactuary.com/t/dumb-excel-questions/5148.md?page=8) [Next page](https://community.goactuary.com/t/dumb-excel-questions/5148.md?page=10)