msword
New Member
- Joined
- Oct 23, 2020
- Messages
- 46
- Office Version
- 2019
- Platform
- Windows
- MacOS
Hi. I have a problem with current tab of a file. After opening security warning about external content pop up. After clicking the "Enable content" button Excel crashes and continues to crash each time after opening the file. Same thing with Office for Mac OS except I can re-open the file there. Re-installation of Office did not helped. Copying tab to a new file did not helped, but i got the "You have copied a connection to an external data source" dialog box. On the top of that I am pretty sure that there are no external links in the file. But there is one pivot table, maybe it is causing the issue.
File:
File:
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| T2 | T2 | =P21 |
| T3 | T3 | =T2/12 |
| P9:P20 | P9 | =SUM(C27,I27,F27,O27,L27,U27,X27,R27,AA27,AG27,AJ27,AD27) |
| Q9:Q20 | Q9 | =P9/$P$21 |
| P21 | P21 | =SUM(P9:P20) |
| AO9 | AO9 | =SUM(C27:C38) |
| AP9:AP20 | AP9 | =AO9/$AO$22 |
| AO10 | AO10 | =SUM(F27:F38) |
| AO11 | AO11 | =SUM(I27:I38) |
| AO12 | AO12 | =SUM(L27:L38) |
| AO13 | AO13 | =SUM(O27:O38) |
| AO14 | AO14 | =SUM(R27:R38) |
| AO15 | AO15 | =SUM(U27:U38) |
| AO16 | AO16 | =SUM(X27:X38) |
| AO17 | AO17 | =SUM(AA27:AA38) |
| AO18 | AO18 | =SUM(AD27:AD38) |
| AO19 | AO19 | =SUM(AG27:AG38) |
| AO20 | AO20 | =SUM(AJ27:AJ38) |
| AO22,AJ40,AG40,AD40,AA40,X40,U40,R40,O40,L40,I40,F40,C40 | AO22 | =SUM(AO9:AO20) |
| AK27:AK38,AH27:AH38,AE27:AE38,AB27:AB38,Y27:Y38,V27:V38,S27:S38,P27:P38,M27:M38,J27:J38,G27:G38,D27:D38 | D27 | =C27/$P9 |
| AL27:AL38,AI27:AI38,AF27:AF38,AC27:AC38,Z27:Z38,W27:W38,T27:T38,Q27:Q38,N27:N38,K27:K38,H27:H38,E27:E38 | E27 | =C27/C$40 |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| U28 | Cell Value | contains "" | text | NO |
| U27 | Cell Value | contains "" | text | NO |
