Excel functionality

We have a Excel Purchase Order template created by someone who is not here anymore. It has a special functionality where a table is presented as a picture to fit into an area. I can't figure out how to adjust so as the table gets longer it displays all rows. I have attached a screenshot as it's hard to describe. need help to figure out how to show all rows from 1 to 38
eXCEL.jpg
Peter MikulaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HuaMin ChenProblem resolverCommented:
Hi,
It means picture file is positioned within the Excel sheet. You can further check any Macro (within Excel file), which is doing some adjustments, to this.
0
Peter MikulaAuthor Commented:
I can't find any macros???
0
Peter MikulaAuthor Commented:
well I see this

Sub Object54_Click()

End Sub

but that's it

where do I look further?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Roy CoxGroup Finance ManagerCommented:
Attach the orkbook. It's not necessarily done with macros.
0
Peter MikulaAuthor Commented:
0
Roy CoxGroup Finance ManagerCommented:
It's not done with macros. It's done with a formula.

The only option that you have is to manually adjust the size of the image. Where's the data from?
0
Peter MikulaAuthor Commented:
when you double click the picture it opens a separate worksheet, I have no idea how it's done, sorry
0
Roy CoxGroup Finance ManagerCommented:
That seems to copy the data to another workbook. I need to know where the data is actually coming from. I'll have  a better look later.
0
Roy CoxGroup Finance ManagerCommented:
The data must be in another workbook. I've just unprotected the sheet and cannot find any data.

Basically you have an embedded activeX image of the data.
0
Peter MikulaAuthor Commented:
it's not, I have taken the spreadsheet out of the network where it was created, this is the file that contains all the data, there are no connections in this file
0
Roy CoxGroup Finance ManagerCommented:
How do you generate the lines of data in that table in the image?
0
Peter MikulaAuthor Commented:
by double clicking on the image, it opens up that "temp" workbook where I can edit the data and it automatically updates the image - magic!
0
Roy CoxGroup Finance ManagerCommented:
So all the data is just manually input. I had actually changed the data and seen this happen. I would say the only option is to re-size the image manually.

I must say it seems a a lot of unnecessary work. Images have been used where the data could be in a cell, see Date in A9 - that's actually an image.

This is how I would link the data to an image. I think the one that you have was created with the Camera Tool, see this
Worksheet-in-Copy-of-016016_PO-14_A.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Peter MikulaAuthor Commented:
when you resize the pic it does not show more rows, the tricky part is that the rows of the middle column don't align with the rest of the spreadsheet columns so it does not look good
0
Roy CoxGroup Finance ManagerCommented:
You can't resize the image to show more rows. it's exactly that - an image of the original data which was created using the Camera Tool. You can add rows to the data, they will reflect in the image. The image cannot be resized without working on the sheet with the image in. You would need to manually resize the image and either add rows below it or increase the height of the rows.
0
Roy CoxGroup Finance ManagerCommented:
The workbook is full of TextBoxes as well as the image of the data. I would really recommend that you consider re-building the workbook with using the TextBoxes, etc. It will be a nightmare to maintain as you are finding now.
0
RayData AnalystCommented:
"when you resize the pic it does not show more rows"
-If you need more rows, insert them into the sheet where you make your entries.  The 'picture' area will be maintained with the new rows automatically.  Test it and see.
 
"the tricky part is that the rows of the middle column don't align with the rest of the spreadsheet columns so it does not look good"
-Click on the "VIEW" ribbon bar and uncheck the 'gridlines' box (see attached image)
EE-Gridlines.PNG
0
Peter MikulaAuthor Commented:
the entries are made in this mysterious spreadsheet that pops up when you double click the image, I don't know how it works, your Gridline idea does not make any difference unfortunately
0
Roy CoxGroup Finance ManagerCommented:
It's an object inserted into the sheet, read this.

Insert an object in your Excel spreadsheet

As I said previously, it is a poor way of creating your document with all those TextBoxes, etc. You would be far better creating a proper form using the normal methods, i.e the sheet cells
0
HuaMin ChenProblem resolverCommented:
Details were provided to resolve this issue
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.