| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unable To Read File - Sumproduct error
Hi
I'm using Sumproduct to count rows that meet certain criteria in external worksheets. If the other sheets are open everything is fine. If not, then I get the error 'Unable to read file'. Can anyone help please? All the files are valid xls files and the path in the sumproduct formula is fine. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable To Read File - Sumproduct error
What you should get when the source file is not open is a #VALUE error
best wishes Bernard Liengme MVP Excel "Fluke" wrote in message ... Hi I'm using Sumproduct to count rows that meet certain criteria in external worksheets. If the other sheets are open everything is fine. If not, then I get the error 'Unable to read file'. Can anyone help please? All the files are valid xls files and the path in the sumproduct formula is fine. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable To Read File - Sumproduct error
Actually, =sumproduct() should work fine if the sending file is closed.
=sumif(), =countif(), =indirect() won't work with closed files. But I don't have a guess why the OP is getting the error message. I know that when I do this, I build the formula with the sending workbooks open and then close those files when the formulas are working ok. (I'll let excel do the heavy lifting and adjust the paths.) Bernard Liengme wrote: What you should get when the source file is not open is a #VALUE error best wishes Bernard Liengme MVP Excel "Fluke" wrote in message ... Hi I'm using Sumproduct to count rows that meet certain criteria in external worksheets. If the other sheets are open everything is fine. If not, then I get the error 'Unable to read file'. Can anyone help please? All the files are valid xls files and the path in the sumproduct formula is fine. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable To Read File - Sumproduct error
I don't. I get a dialog box that says 'Unable to read file'.
"Bernard Liengme" wrote: What you should get when the source file is not open is a #VALUE error best wishes Bernard Liengme MVP Excel "Fluke" wrote in message ... Hi I'm using Sumproduct to count rows that meet certain criteria in external worksheets. If the other sheets are open everything is fine. If not, then I get the error 'Unable to read file'. Can anyone help please? All the files are valid xls files and the path in the sumproduct formula is fine. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable To Read File - Sumproduct error
Dave,
Just did an experiment in XL2007 and got #VALUE! with sending file closed and expected result when it is open. best wishes "Dave Peterson" wrote in message ... Actually, =sumproduct() should work fine if the sending file is closed. =sumif(), =countif(), =indirect() won't work with closed files. But I don't have a guess why the OP is getting the error message. I know that when I do this, I build the formula with the sending workbooks open and then close those files when the formulas are working ok. (I'll let excel do the heavy lifting and adjust the paths.) Bernard Liengme wrote: What you should get when the source file is not open is a #VALUE error best wishes Bernard Liengme MVP Excel "Fluke" wrote in message ... Hi I'm using Sumproduct to count rows that meet certain criteria in external worksheets. If the other sheets are open everything is fine. If not, then I get the error 'Unable to read file'. Can anyone help please? All the files are valid xls files and the path in the sumproduct formula is fine. -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable To Read File - Sumproduct error
Dave,
I am sorry I contradicted you. My experiment was in XL2007 running under Windows 7 RC. I tried again on my old PC and got what we both expected - SUMPROCDUCT does no need the sending file to be open. I will try again on new PC to see if my example was a bit odd. best wishes Bernard "Dave Peterson" wrote in message ... Actually, =sumproduct() should work fine if the sending file is closed. =sumif(), =countif(), =indirect() won't work with closed files. But I don't have a guess why the OP is getting the error message. I know that when I do this, I build the formula with the sending workbooks open and then close those files when the formulas are working ok. (I'll let excel do the heavy lifting and adjust the paths.) Bernard Liengme wrote: What you should get when the source file is not open is a #VALUE error best wishes Bernard Liengme MVP Excel "Fluke" wrote in message ... Hi I'm using Sumproduct to count rows that meet certain criteria in external worksheets. If the other sheets are open everything is fine. If not, then I get the error 'Unable to read file'. Can anyone help please? All the files are valid xls files and the path in the sumproduct formula is fine. -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable To Read File - Sumproduct error
That would be disappointing if some functions broke in Win7RC1. A major
disappoinment if they continued to be broken with Win7. Bernard Liengme wrote: Dave, I am sorry I contradicted you. My experiment was in XL2007 running under Windows 7 RC. I tried again on my old PC and got what we both expected - SUMPROCDUCT does no need the sending file to be open. I will try again on new PC to see if my example was a bit odd. best wishes Bernard "Dave Peterson" wrote in message ... Actually, =sumproduct() should work fine if the sending file is closed. =sumif(), =countif(), =indirect() won't work with closed files. But I don't have a guess why the OP is getting the error message. I know that when I do this, I build the formula with the sending workbooks open and then close those files when the formulas are working ok. (I'll let excel do the heavy lifting and adjust the paths.) Bernard Liengme wrote: What you should get when the source file is not open is a #VALUE error best wishes Bernard Liengme MVP Excel "Fluke" wrote in message ... Hi I'm using Sumproduct to count rows that meet certain criteria in external worksheets. If the other sheets are open everything is fine. If not, then I get the error 'Unable to read file'. Can anyone help please? All the files are valid xls files and the path in the sumproduct formula is fine. -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable To Read File - Sumproduct error
If you open both files, does the formula calculate correctly?
Does the formula point at the correct file (dropping the drive and path)? And if you close the "sending" file and recalc, do you still get that error message? I don't have a guess, but maybe someone else will with further information. Fluke wrote: I don't. I get a dialog box that says 'Unable to read file'. "Bernard Liengme" wrote: What you should get when the source file is not open is a #VALUE error best wishes Bernard Liengme MVP Excel "Fluke" wrote in message ... Hi I'm using Sumproduct to count rows that meet certain criteria in external worksheets. If the other sheets are open everything is fine. If not, then I get the error 'Unable to read file'. Can anyone help please? All the files are valid xls files and the path in the sumproduct formula is fine. -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable To Read File - Sumproduct error
My bad, I cannot reproduce this so who knows what I did. Senior moment maybe
-- Bernard "Dave Peterson" wrote in message ... That would be disappointing if some functions broke in Win7RC1. A major disappoinment if they continued to be broken with Win7. Bernard Liengme wrote: Dave, I am sorry I contradicted you. My experiment was in XL2007 running under Windows 7 RC. I tried again on my old PC and got what we both expected - SUMPROCDUCT does no need the sending file to be open. I will try again on new PC to see if my example was a bit odd. best wishes Bernard "Dave Peterson" wrote in message ... Actually, =sumproduct() should work fine if the sending file is closed. =sumif(), =countif(), =indirect() won't work with closed files. But I don't have a guess why the OP is getting the error message. I know that when I do this, I build the formula with the sending workbooks open and then close those files when the formulas are working ok. (I'll let excel do the heavy lifting and adjust the paths.) Bernard Liengme wrote: What you should get when the source file is not open is a #VALUE error best wishes Bernard Liengme MVP Excel "Fluke" wrote in message ... Hi I'm using Sumproduct to count rows that meet certain criteria in external worksheets. If the other sheets are open everything is fine. If not, then I get the error 'Unable to read file'. Can anyone help please? All the files are valid xls files and the path in the sumproduct formula is fine. -- Dave Peterson -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable To Read File - Sumproduct error
Never happens to me! Ahem, please stop laughing!
Bernard Liengme wrote: My bad, I cannot reproduce this so who knows what I did. Senior moment maybe -- Bernard "Dave Peterson" wrote in message ... That would be disappointing if some functions broke in Win7RC1. A major disappoinment if they continued to be broken with Win7. Bernard Liengme wrote: Dave, I am sorry I contradicted you. My experiment was in XL2007 running under Windows 7 RC. I tried again on my old PC and got what we both expected - SUMPROCDUCT does no need the sending file to be open. I will try again on new PC to see if my example was a bit odd. best wishes Bernard "Dave Peterson" wrote in message ... Actually, =sumproduct() should work fine if the sending file is closed. =sumif(), =countif(), =indirect() won't work with closed files. But I don't have a guess why the OP is getting the error message. I know that when I do this, I build the formula with the sending workbooks open and then close those files when the formulas are working ok. (I'll let excel do the heavy lifting and adjust the paths.) Bernard Liengme wrote: What you should get when the source file is not open is a #VALUE error best wishes Bernard Liengme MVP Excel "Fluke" wrote in message ... Hi I'm using Sumproduct to count rows that meet certain criteria in external worksheets. If the other sheets are open everything is fine. If not, then I get the error 'Unable to read file'. Can anyone help please? All the files are valid xls files and the path in the sumproduct formula is fine. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Unable to Read File" error message in Excel - solutions? | Excel Discussion (Misc queries) | |||
| Unable to read error in a pivot table | Excel Discussion (Misc queries) | |||
| "Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
| Error boxes when opening Excel "unable to read file" then "open X. | Setting up and Configuration of Excel | |||
| Trying to open Excel/Word files error message "Unable to read file | Excel Discussion (Misc queries) | |||
![Fluke[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
