Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,771 questions
Xero export file cannot use excel formula.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 57.99999999999999%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
Phyon Lau
0
Reputation points
Hi,
Good morning.
I have a problem with the Xero export file.
Communicated with Xero online support which finally pushed me to contact Microsoft.
Question:
QUOTE:
If you are struggling to create a formula on an Excel Spreadsheet, regardless of the spreadsheet being exported from Xero you'll need to speak to Microsoft to identify the cause of this error. As this is an issue external to Xero, we're unable to complete any troubleshooting steps to fix the issue you're experiencing.
UNQUOTE
I cannot use xlookup in exported Xero files.
I have around 1,700 transactions that need to be recognized.
1 file by original excel and 1 file by Xero exported.
Can you please help me?
Thank you!
Sign in to answer