how to modify a range of an excel link

New Here ,
Mar 28, 2022 Mar 28, 2022

Copy link to clipboard

Copied

I have a book with several links to excel 

now I need to modify some of the range (as excel table are currently longer / larger)

how can i do?

TOPICS
Import and export

Views

32

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Mar 28, 2022 Mar 28, 2022

Copy link to clipboard

Copied

LATEST

You might try to select the content of the entire table. Then use the Place command with the Show Import Options to place the same spreadsheet file, but choose a smaller data range in the Options dialog box.

 

Or, if you have simply refreshed the link, you could manually select the unnecessary columns and press Cmd/Ctrl+Backspace to delete rows or Shift+Backspace to delete columns.

Mike Witherell

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines