4

I'm getting a "!(cell) Is Not In Table" error when attempting to create a Relative cell reference, inside of an outlook table, when using a formula.

I've tested the formula functions and they seem to work as long as I use an Absolute reference (with the format of R1C2, meaning Row 1, Column 2).

However, Microsoft's support page on the topic states that you can simply use R to refer to the row of the formula, and C to refer to its column, to create a Relative reference (so RC1 should refer to the 1st column of the formula's row).

But, whenever I try that, the formula outputs the "!RC1 Is Not In Table" error:

Example of working and non-working formulas

Anyone know how to make a relative-referencing cell in Outlook?

(Note: Because of my department's security changes to Outlook, an embedded Excel spreadsheet will not work.)

Man_Over_Game
  • 128

2 Answers2

0

How do you create the table in Outlook email? Insert > Table?

Try click Insert > Table > Excel Spreadsheet. Then you can use the reference as the same in Excel.

enter image description here

Perry
  • 1,281
0

I have a gut feeling the RnCn notation is an absolute address notation... although I couldn't find any official statement and I couldn't find any example for a relative address on the net for Word/Outlook tables. Who knows, maybe the support page is referencing s.th. that was never implemented, but I might be wrong there.

But if you want to use relative references in order to be able to add rows/columns (in your case I assume it's rows) without making changing all your formulas, you can use bookmarks as a work around:

  • Select a cell you want to reference
  • In the Ribbon goto "insert" and select "insert link" from the link-button dropdown menu
  • Reference the cell by using the bookmark and not the cell address

If you add a row/column the bookmark will change accordingly, so your formulas will keep working.

(tested on Office 365)

Albin
  • 11,950