Resize to show all values

[Legacy 185509]

Hi
I am using some addon to get some values into the cell from some server,
everytime I clear that cells and click get data I get this on cell instead of the data "Resize to show all values" so what I would have to do is click on that cell after what addon box on right side will open on automatically and in that box I have to click apply or ok for it to get the data is there better way do this, I have over 200 cells like this if i do for all 200 cells I will be dead
plz help
addon is call PI system/historian
thank you

 

[Desu Nota from Columbus]

Could you try selecting all cells and then click Format>Column> AutoFit selection?

 

[Legacy 185509]

No, I tired all that, I think it has to do with like clicking ok, by doing that it would fetch the data from server.
read first post and just out other reply briefly, post 7 has solution
http://www.rjksolutionsltd.co.uk/forum/yaf_postst273_how-to-auto-update-pi-value-in-excel-.aspx
but it won't work for me.
do you know anything about dlresize method in excel?

 

[Desu Nota from Columbus]

You added the PIDLDialogs.xla as a reference (in VBA go to Tools>Reference>Check/Add) in Visual Basic and then tried this code?

Private AutoUpdate()

Range("A1:E1000").Call dlresize 
`Change range above to your desired range
End Sub

Because what that link said was that there is a built-in program within the PI software that fixes your problem. You have to add a link (reference) so VBA can access and utilize it.

 

[Legacy 185509]

nvm I was able to click on it after reopening it
I found the file and I clicked the check box and inserted the code you gave

Private AutoUpdate()

Range("J1").Call dlresize
`Change range above to your desired range
End Sub

I get compiling error for that,
and for

Call dlresize
End Sub

I try to run this I get this error "DLresize:1004: No cells were found."

 

[Desu Nota from Columbus]

Sorry I can't help you I am not familiar with the software.