I get #Name? Error when I copy the File from Remote(where my jet resides) to the my Local drive.

Johnson Patrick

March 30, 2021 08:25

None

Hello Experts,

I have created a Jet Report which has almost 32 tabs(pretty complex, I know), when I copy the report from the remote laptop(where the Jet Resides) to my Local drive, it throws #Name? Error in the place where I have used NL & NF functions instead of displaying values.

I have been slogging to fix this from past 2 days but no luck! Any help/suggestions would be greatly appreciated.

Thanks in advance!

Date Votes

1 comment

0

Bryan Robinson March 30, 2021 16:07

I would do a Find and Replace to get rid of those references to the xlam file.

Should be able search for 'C:\Program....xlam' and just replace with nothing.

But this is an Excel thing, not necessarily a Jet thing.

Comment actions Permalink

Please sign in to leave a comment.