What will display when trying to insert an XFGetCell and you are not logged into the Excel Add-In?

What will display when trying to insert an XFGetCell and you are not logged into the Excel Add-In?

• A. #Error
• B. #LogOn
• C. #Refresh
• D. #Login

Answer: (B)

Not having an active session in the Excel Add-In means there’s no authenticated connection to request data. XFGetCell relies on that session, so without login it returns a status that tells you to sign in. That status is #LogOn, signaling you must log into the Add-In before the function can execute. Once you log in, XFGetCell can fetch and display the actual value. The other options don’t match the Add-In’s signaling in this scenario: they aren’t the specific notification used to indicate you need to log on.

Not having an active session in the Excel Add-In means there’s no authenticated connection to request data. XFGetCell relies on that session, so without login it returns a status that tells you to sign in. That status is #LogOn, signaling you must log into the Add-In before the function can execute. Once you log in, XFGetCell can fetch and display the actual value. The other options don’t match the Add-In’s signaling in this scenario: they aren’t the specific notification used to indicate you need to log on.