Forum Discussion

victor's avatar
victor
Copper Contributor
Apr 23, 2018

Access and Excel Link Problem #Number

Hello everyone,

I come to you because I have a thorny problem with the links established between my Access database and my Excel files.

In the preamble, it will be important later (I think), I'm working on Excel 2016, on a Windows 7 computer.

I usually reprocess the information (contained in my database) in reports designed in Excel, fed via a TCD linked to a query stored on my database.
Until last Tuesday, it was okay, all my reports worked. Until ... I do not know exactly what...
So last Tuesday, I open one of my reports and launch a refresh of the data. Then appear # NUMBER in some cells, which returned me a result so far. Strange.

By double clicking on the cells concerned by the #NUMBER, I identified on the extracts of requests that were returned to me some lines, some cells of which, obtained by calculation, sent me an error #NOMBRE. These calculated cells have as a common point to result from the multiplication of a criterion by another of value equal to 0.
Via Access, browsing my request, I found the lines concerned. No error in the corresponding cells when I observe them via Access. I tell myself that it makes sense that 0 x Whatever = 0.

Yet on Excel: 0 x Whatever = #NUMBER.

So I guess the problem comes from Excel ... But maybe I'm wrong?

I tested a reporting update via another post (Windows 10), and it works nickel ...

But where does this come from? I talked to my computer partner, he formatted my computer, uninstalled reinstalled office. NOTHING. the problem persists. Finally on my post ... Who is the one on which I designed my reports via Access -> Excel link.
Still, I do not think I have changed anything ... Are there any checkboxes in Access / Excel that cause this type of error, or on the contrary, make it possible to take into account the calculations in the query extractions?

In the screenshot below, we see the cells in error , obtained by double clicking on an error appearing on my TCD (which draws in Access), and looking for errors in the given table appearing .

here is below the same ligns as i see them through Access:

I do not know if I'm very clear, in which case do not hesitate to tell me, and if by chance, you had any idea of ​​any solutions or tests to perform, I am ultra taker and thank you strongly in advance,

In any case, thank you for the time you took to read me!
Victor
 

No RepliesBe the first to reply

Resources