135 reputation
18
bio website jonathan-allred.com
location Arizona
age 29
visits member for 1 year, 9 months
seen Jul 15 at 22:45

Technologist


Jun
10
awarded  Popular Question
May
29
awarded  Teacher
Feb
6
awarded  Notable Question
Jan
30
answered How can I modify the “Picture Styles” shortcut gallery in Microsoft Office (Word and Powerpoint, specifically)?
Jul
30
awarded  Popular Question
Jul
19
accepted How can I modify the “Picture Styles” shortcut gallery in Microsoft Office (Word and Powerpoint, specifically)?
Jul
4
awarded  Tumbleweed
Jun
27
asked How can I modify the “Picture Styles” shortcut gallery in Microsoft Office (Word and Powerpoint, specifically)?
Apr
22
asked Would it ever make sense to have a much lower upload speed than download speed in a fiber optic network?
Jan
15
comment INDIRECT gives a #REF! error for reference to external workbook where making a direct reference with an equal sign works. Why?
That's the problem: part of my ADDRESS calculation is calculating which worksheet to reference. But good to know that INDEX is the preferred method in other cases.
Jan
14
comment INDIRECT gives a #REF! error for reference to external workbook where making a direct reference with an equal sign works. Why?
I'm not sure if INDEX will work with what I'm doing, but just in case, what is the benefit of using INDEX over INDIRECT?
Jan
14
awarded  Scholar
Jan
14
comment INDIRECT gives a #REF! error for reference to external workbook where making a direct reference with an equal sign works. Why?
The other notebook is arranged in a way that a direct reference would take a lot of hand-coding. Instead, I use ADDRESS to calculate the reference. My actual address argument is a bit more complicated than I've presented it here, but since I managed to identify the problem as a difference between the "=" operator and the INDIRECT operator, I simplified a bit for clarity.
Jan
14
accepted INDIRECT gives a #REF! error for reference to external workbook where making a direct reference with an equal sign works. Why?
Jan
14
comment INDIRECT gives a #REF! error for reference to external workbook where making a direct reference with an equal sign works. Why?
Apparently it has something to do with whether I have the externally referenced workbook opened at the same time. I'm not sure why the INDIRECT operator needs both opened simultaneously when the "=" operator does not.
Jan
14
asked INDIRECT gives a #REF! error for reference to external workbook where making a direct reference with an equal sign works. Why?
Dec
18
awarded  Supporter
Oct
26
comment In PowerPoint, is there a way to create a printable version of an animated slide?
Is there a way to do the reverse: hide slides by default from the printer?
Oct
26
awarded  Student
Oct
26
asked In PowerPoint, is there a way to create a printable version of an animated slide?