Hi,
Yes, it is possible to link to a Power Query from an external workbook.
Here's how you can do it-
Open File B, the workbook where you want to display the data from the Power Query.
In Excel, go to the "Data" tab in the ribbon and click on "Get Data" or "From Other Sources".
Select "From...
Hi Gvn Kumar,
It seems that the file you saved in Excel 97-03 mode has a different file format and extension than what is expected for a file created using Office 365 Excel. This error message indicates that the file may be corrupted or unsafe, so proceed with caution.
To open the file, you can...
Hello everyone,
You can call me Lori. Happy to be here, I use excel on daily basis and will definitely face some challenges. Looking forward to helping and being helped. :p
Hi vasim,
I see you have accidentally shift-deleted your file but you have recovered the file.
No worries, Repairing the workbook will fix the issue:
1. Open Excel APP.
2. Click on File > Open.
3. Select your File (single click) and click on the drop-down arrow next to the "Open" button.
4...
Hi BBKP,
This error happens while opening an older version of an Excel file in a newer version.
I'm not very sure if the file corrupted because of a hard drive crash can be repaired or not but if it can be, you can try changing the excel file extension to ".xls".
1. Go to your file explorer...
Hi Reijo,
This is a very common error and it usually occurs due to incompatibility between the excel files and versions.
I suggest you try to change the Excel File Permissions.
Basically, the objective of doing this is to provide you with all the permissions of the file if you don't happen to...
This unreadable content error may occur due to the different functions, macros, or formulas used in the file. The error message persists when these objects of the excel file give error then you need to repair the contents of the workbook. Because the file is corrupted.
Please go through the...
Whenever corruption occurs in the workbook, Microsoft detects itself while opening the File and goes into file recovery mode. And Microsoft provides an in-built feature, i.e., Open and Repair.
Follow the below steps:
Click on File and Open.
Select the location and folder that contains the...
Sometimes users are troubled with different types of runtime errors by which they unable to access their Excel file. One of them Excel errors is “File Error: Data May Have Been Lost”.
In order to repair the damaged excel file you have to perform the following steps:
Open the excel file.
Now...
Hi Alice,
I am glad to assist you.
There are possible causes for this error.
If you’re using an unsupported Excel file format or maybe the file is corrupted due to sudden power off. And when opening an older version of the excel file in a new version on MS Office, this error may occur.
And...
Open and repair option doesn't work in every case. If your file is severely corrupted then, you can take the help of Microsoft support or try Excel repair software.
I am going to share few solutions to repair corrupt Excel file:
Solution 1: Open and Repair
This is inbuilt option to repair an Excel file. To use this:
Open MS Excel instance
Navigate on File->Open
Select the file which you want to repair
Choose ‘Open and Repair’ option
Click Repair...
This video is created by Chris Menard who is Financial Systems Trainer, Microsoft Office Master Instructor and Public Speaker about to repair corrupt Excel file: https://www.youtube.com/watch?v=srxcSxHR9t4
Solution 1 Open and repair
Solution 2 Delete COM Add-Ins
Also check these links: https://support.office.com/en-us/article/Repair-a-corrupted-workbook-153A45F4-6CAB-44B1-93CA-801DDCD4EA53...
Hi Shaboo,
Follow these steps to share the Excel file for multiple users:
Open Excel file that you want to share.
Go to Review section and click on the Share Workbook option.
Now, in the editing tab, select the check box "Allow changes by more than one user at the same time. This will allow...
Try to repair MS Office. Go to control panel and select the MS Office program from Programs and Features.
Right click on the program and select Change option.
Select Repair radio button and click on Continue button.
Good Luck!