When I create a link inside of Excel to another portion of Excel, no problem.
Working: Q:\workbook.xlsm#sheet!A1

But when I copy that to OneNote it cannot find the file.

There must be a path that will do it, no?